BDE doing things it shouldn't
> I'm using Delphi 3 and Interbase 4.2 and have found that the BDE is From past experience with both Oracle and Interbase, I have found and
> doing some some strange things with my tables. The database structure is
> fairly complex and at some points I need to have 30-40 tables open at
> once. When I do a simple update to one table, I notice it takes longer
> than it should. After monitoring the situation with SQL Monitor in
> Delphi, I noticed that the BDE is updating the modified table correctly,
> but then proceeds to refresh almost every open table in the database!
> doesn't touch them. Is it because I have so many tables open? I thought
> the BDE should be able to handle this. If anyone can help or has
> experienced something like this before, I would appreciate the help.
recommend using stored procedures to do your inserts, updates and deletes.
Use queries only to retrieve datasets from tables and views. Use views as
the basis of reports whenever possible since a join of two tables into a
view can, if done right, make your report writing easier and faster. A
stored procedures can be used by several windows for related updates and
can be put into triggers to cascade things such as a series of deletes to
be carried out on related tables. An added note about the Delphi table
component. It amazes me to hear that people are still doing table1.open in
FormCreate when the dataset they are caching has some 10,000 records.
Don't their customers have anything better to do than to wait 10 minutes
for a window to open?