Subject Re: SQL Hourglass et. al.
Author Rick Roen
There are others that frequent this list who are much better
qualified than I to answer most of these questions, but do yourself
a HUGE favor and buy "The Firebird Book" by Helen Borrie (also
frequently in this ng). You can buy on Amazon new or used. It will
cover nearly everything you need to know about indexing and much,
much more about FB in general.

As for cascading deletes etc. You are already executing all your
deletes and indeed all sql commands on the server anyway. You could
always test out the difference in a test-production environment.

You will normally want to convert to the TIB_Query etc set of
components. The ones you are using are only a bridge to the real
thing and much more functionality.



--- In, "Anthony Tanas" <anthony@...>
> Hello everybody,
> I'm new to IBObjects and to this list.
> I just converted my program over to the IBOBjects Tdataset
module. It was
> amazingly fast and easy! I was so excited about jumping back on
it today
> that I was up before the crack of 11 AM!
> My questions:
> 1) How can I reintroduce the "SQL Hourglass" behavior that I got
with BDE
> components? Now I don't get an hour glass. In most places I can
> Screen.Hourglass but I have a few databound grids with huge
datasets that
> grind a bit when scrolling and get no hour glass at all.
> 2) How much of a performance gain would I get by converting my
executed SQL
> statements (INSERT, UPDATE, DELETE) that are currently in the
> equivalent into the component (I forget what it's called) with
the "low
> overhead" SQL components.
> 3) Please give me some pointers on indexing to increase
efficiency. During
> most of my career as a corporate programmer we had a DBA who took
care of
> the database stuff like this. Now I'm on my own. Is setting up
foreign key
> contraints important for performance or just for data integrity?
What's a
> good place to learn about stored procedures?
> Like for example right now if I delete a Billing Number (like an
invoice) in
> my system, I first delete the billing items, and before that the
> towards each item (it's medical related so payments are for
> items)...and I do this in my client program by executing delete
> Is this something that should be done on the server (I seem to
> something about ON DELETE CASCADE from my database class in
> On the other hand if I move functionality to the server then I am
going to
> be more tightly attached to firebird. Is this a good bet?
> Thanks,
> Anthony