Hi Helen,

Can you please explain "- don't forget about GROUP BY for getting totals."
Up until now I've been running a separate dataset to display totals, are you
implying there's an easier way ?

Regards

Beyers

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Monday, May 24, 2004 12:02 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re: Speed difference between TIBQuery and TIB_Query?


At 02:40 PM 23/05/2004 +0000, you wrote:

>--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> > The first comment is - it's astonishing that you are using the
>client to do
> > this non-interactive processing in a client/server system.
>
>This is a temporary situation while another developer works on a set
>of stored procedures to handle this. I started working on the
>client side stuff as a stop gap because his efforts were taking
>longer than expected and we needed something in the mean time.
>
> > Are you aware at all of the
> > benefits of using prepared statements and substitutable
>parameters, or
> > would you like that explained?
>
>I understand. It's been a while since I've worked with C/S and it's
>coming back to me in pieces.
>
> > Render unto the desktop that which is the desktop's. If you
> > want performance, get into the "client/server groove".
>
>Do you have any suggested reading?

Have you picked up the TI sheets from www.ibobjects.com/TechInfo.html ?The
ones on Client/Server programming and Datasets would be a good place to
start.

"Think thin", especially for non-interactive utilities.
Don't assign SQL in loops. Seriously exploit the WHERE clause and
replaceable parameters - prepare once, run often.
Don't destroy and recreate objects that you will use repeatedly.

Use tib_dsql for straight DML. Use ib_cursor for sets you have to walk
through.
Don't request multi-row sets if you can get the same data from a singleton
- don't forget about GROUP BY for getting totals.

Helen




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links





This is an email from CS Holdings. It is confidential to the ordinary user of the email address
to which it is addressed and may contain copyright and/or legally privileged information. No one
else may read, print, store, copy, forward or act in reliance upon all or any part of it or its
attachments. If you received this email in error please notify its sender.