> I would like to ask is there any programming strategy, hint,
> approach, idea to make faster my application?

for those comboboxes - are those filled with hundreds and thousand of
records?!
try to use another kind of control (for example a small button to the left
of the entry field opening a selection window) for that purpose.

reduce the number of queries fired from the client by using on (huge) joined
query or a selectable stored proc and handle the insert and updates with a
stored procedure as well.

I use this techniques regularly and get very good results...

> "640kb should be enough memory for everyone"
> Bill Gates 1984
>
> Christian Kaas Software development
> www.ckaas.de

> -----Ursprungliche Nachricht-----
> Von: Ca?atay TENGYZ [mailto:tmd0307@...]
> Gesendet: Donnerstag, 31. Mai 2001 10:13
> An: IBObjects
> Betreff: [IBO]
>
>
> Hello list,
>
> I've written a program for library that holds the records of the
> books in the library. So I've got a data structure sth like that :
>
> Master Books Table -> about 70.000 records
> Master Writers Table -> about 90.000 records
> Master Subjects Table -> about 40.000 records
> Master Translators Table -> about 5.000 records
> and other master data tables,
> and also relation tables such as
> Books-Subjects Relations -> about 110.000 records
> Books-Writers Relations -> about 120.000 records etc...
> (you know a book can have more than one writer or a book's
> content may fall into more than one subject title)
>
> So in my application on the main data entry form I've got lots of
> queries, lookup combos and queries that fills those combos. When
> browsing between records it takes a while to get data from database.
>
> I would like to ask is there any programming strategy, hint,
> approach, idea to make faster my application?
>
> Best regards.
>
> M. Cagatay Tengiz
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>