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.

HTH,

Rick

--- In IBObjects@yahoogroups.com, "Anthony Tanas" <anthony@...>
wrote:

>
> 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

set

> 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

Tquery

> 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

payments

> towards each item (it's medical related so payments are for

individual

> items)...and I do this in my client program by executing delete

statements.

> Is this something that should be done on the server (I seem to

recall

> something about ON DELETE CASCADE from my database class in

college).

>
> 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
>