🚀 go-pugleaf

"Jarek Bialik" <jbialik@telusplanet.net> wrote in message
news:418c133c$1@newsgroups.borland.com...
> Hi all
>  I implemented a client solution running om IB 6 opensource, this was
years
>  ago and the database / table structure is defintely not optimized. In
terms
> of
>  indices and referential constraints and cascading deletes, I know all of
> this
>  stuff now but like I said this was years ago. Anyways I have a query of
the
> form
> Delete From PaymentsWip Where WipNo in
>
> (select WipNo From InternalInvmaster Where (Cast(inqDate as Date) <=
> '12/31/2001'))
>
>  and its really slow, and I need to have about 10 of these run on separate
> tables,
>  I tried to backup and restore and sweep and then ran the query, but that
> only shaved off
>  4min on a 20 min query,
>
> the question , should I create an Index on the inqDate fields, and is the
> "in" operator
> in the SQL the issue, can I re-wite the query? Also I was running this
right
> from the IBConsole.
>
> any suggestions would really be helpful as I need to dump a bunch of data
> monday morning
> at the client site?

Updates and Deletes using subqueries are not optimized and can run very
slowly on large result sets.  I would recommend writing a stored procedure
instead.

Dan