DatabaseOpen() slow over network

Tue Apr 15 22:43:23 CDT 2003

on 4/15/03 8:37 PM, X Y at xyzabc1010 at yahoo.com wrote:

> Hi All,
> Thanks for the response. However, I did the following:
> tried opening 2 different DB on same network, same
> machine, etc.
> 
> 1 DB - it took milliseconds to open\
> 2nd DB - it took around 3 - 5 secs?

The more tables you have the longer it takes to open.

Actually speed of open is affected by
1) count of VarChar fields
2) count of indexes.

May be your second db do reindexing on open ?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------