Hello,
i want to speedup my IBObjects Program - but i dont know the right way to do it. I would be thankfull for any help and directions how to start.
THE SETTING:
Firebird 1.0 versa TCP/IP
IBObjects 4.2HH and C++ Builder 5
8 Tables (independent from each other)
Users: About 12

THE WAY I DID IT:
A Data-Formula
1 TIB_Database
8 TIB_Query
8 TIB_DataSource
8 TIB_CtrlGrid
and different DataAwareControls like TIB_Edit, TIB_Memo TIB_RadioGroup
8 TIB_UpdateBar

The Program connects the TIB_Database and sets the TIB_Query active. All works fine.
But if the user changes the active dataset, the change is relatively slow.

THE WAY I THOUGHT I COULD GET BETTER:
I forced the program to choose EVERY Dataset of all tables one after the other at the start of the program. This way it takes about 5 min to get the data from about 100 Datasets! 5 min for only about 300kb of data.
--> Not really better.

THE QUESTION:
How should i change the program for better performance? What kind of techniques should i use?


Thanks for your help
Sönke Klinger.


[Non-text portions of this message have been removed]