[TM4J-users] Too many topics?

[Andrea C. <mai...@st...>]

Hi all,
I am developing an application which, basing on a Hibernate backend, does
something which is very similar to what the program sent by Richard does,
that is: 
- retrieving a result set from a db
- reading each row of the result set and making use of these data to create
topics in a topic map. Each topic is created with a base name, a subject
indicator and a type.
 
The problem is that processing 600 topics takes several minutes on a
powerful computer (Pentium 4, 2.4 GHz), and I wanted to process at least
1000 topics in a much shorter time!
I tried to run the same program with an in-memory backend: it executed
within one second!
So, I think the problem is that I make use of a database.
My questions are: 
-          is this long processing time normal? If yes, what does it depend
from?
-          Does a solution exist (at least to reach a shorter execution
time) or should I accept the idea of working with much smaller topic maps
(or with an in-memory backend)?
 
I hope someone can help.
 
Thanks in advance!
Andrea