Hi!

The help say that if I used foreign keys, then EDB open the referenced tables too to check the FKs.

I not fully understand what's that meaning, but I think this meaning that server keep open the these tables in the background...

If we wired the DB with FK-s, may we open near to 80% of tables.

May this binding to user session or are these "opened" tables global?

This is interesting question because if these tables are binded to user session, then we have 170 users (sesssions), we need [170 * TablesOpened] memory.  

But if these tables are global opened, then memory usage is not too high, because we open these tables later in the program.

Or what's the meaning of "open referenced tables" in the help?

Thank you for the help!

Sincerely:
  dd

<< If we wired the DB with FK-s, may we open near to 80% of tables. >>

Yes.

<< May this binding to user session or are these "opened" tables global? >>

They are opened globally at the engine/OS file level, and session-based at
higher levels where there is session-specific information and buffering.

<< This is interesting question because if these tables are binded to user
session, then we have 170 users (sesssions), we need [170 * TablesOpened]
memory. >>

Correct.

--
Tim Young
Elevate Software
www.elevatesoft.com