Slow start up times

[Ruslan Zasukhin]

On 16/2/08 7:05 PM, "Thorsten Hohage" <thohage at objectmanufactur.com> wrote:

> b) You must make a difference between VServer and client and "local"
> system. The first start of the first client is (much) slower then any
> other start due to the fact, that the VServer must load the db at this
> point.
> 
> A good feature request might be an option "Load DB at startup" like
> some other DB offers, but a small simple app, just doing a connection
> and a "select * from ..." on all needed DB on the server at startup
> would do the trick and DOES the trick very efficiently for one of my
> apps (restaurant cassier) where the speed up time of client was
> critical.

I think no need do SELECT * even. It is enough connect and open db.

Also TIP: SELECT *    often better replace on SELECT RecID


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]