Hi List,

This message is probably for Jason but if anyone has input on this
please reply.

I need to understand thoroughly how schema cache works in order to
make some improvements to it.

We have done extensive network monitoring to see how does it impact
the network and it looks like it sends thousands of tiny packages of
about 32 to 64 bytes each in order to populate the schema cache
folder. On a low latency network this is not a problem but when the
latency grows this becomes a serious issue.

Connecting to a database with about 204 tables and about 30 fields
each took 2 hours and 30 minutes over a 0.4 latency internet
connection.

We are interested in investing time into this issue and for that we
need to understand how it works indepth.

Thank you.

Calin Pirtea.
Medisys Australia Pty Ltd.
www.medisys.com.au
calin.pirtea@...