Hi,

Thanks for all your help. because of it I have successfully retrieved some
records form db using OJB. 

However I found out another issue: performance-wise ojb is rather slow. 

When I time the whole operation (retrival of 20 records and print some
trivial message), it gives the following result:

real    3m12.765s
user    0m2.530s
sys     0m0.020s

My observation is that it takes quite a long while to initialise. I reached
this conclusion because:

First I see the following message in stdout
...
pool configuration was: {whenExhaustedAction=0, maxIdle=-1, maxActive=21,
maxWait=5000, numTestsPerEvictionRun=10, testWhileIdle=false,
testOnReturn=false, timeBetweenEvictionRunsMillis=-1,
minEvictableIdleIimeMillis=600000, testOnBorrow=true}
...
and then after quite a while i see a sql statement is sent to the db

After that the result is displayed rather quickly.

So, Questions: 
1) what is going on during initialiation? Is it expected?
2) Is there anything I can do to speed this up? 
3) Some other jdo packages actually created some auxillary tables in the
target db but I did not find similar thing in OJB. Does this mean i have
missed something when i setup OJB?



Regards,



Anthony





--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to