brwoser and database performance

[myilmaz]

When my project on win2000 server and connect client, I am living decrease performance my database.
And I have searche browser like this Query
For Each AA
Each BB OF AA
Each CC OF AA


What can I do to increase performance of database and this type browsers.
Thank You For ALL

 

[vinod_home]

you can try to use the field-list in the for commands, that way you have only a selected fields to be pulled from the database thus reducing the time it takes.

If the delay is cause of number of records in the table/s , then you could also work with temp-tables and only select few records from the database .

HTH
V

When my project on win2000 server and connect client, I am living decrease performance my database.
And I have searche browser like this Query
For Each AA
Each BB OF AA
Each CC OF AA


What can I do to increase performance of database and this type browsers.
Thank You For ALL