Subject Re: [IBO] TIB_Database, Query, Datasource, Memo: How can i speed up this system?
Author Svein Erling Tysvaer
do you really mean that you open 100 datasets? From your description it
sounds more like eight.

The main thing for improving performance is to think client/server. You're
bound to fail if you treat Firebird similar to desktop databases or
spreadsheets. One of the first thing you should ask yourself is "Which
record(s) will the user work with?" and then you make sure you only read
and display those records. 300 kb isn't much for a computer, but most of us
human beings cannot work on that much information at the same time (this
message only contains 1289 characters including spaces and in many cases
even that is too much), and I am inclined to think that you are
transferring too much data from the server to your client.

I normally use TIB_Connection and TIB_Transaction rather than TIB_Database,
but I don't think this really matters much. You should consider whether
your data requires a TIB_Query (bidirectional scrolling) or if TIB_Cursor
could suffice (unidirectional). TIB_ControlGrid is probably useful even
though I've never used it myself, but make sure that this is what you want
and not just a TIB_Grid.

Try to find your bottleneck using a TIB_Monitor (or something with a
similar name) and tell us in more detail about those things that appear to
be timeconsuming.