Subject Re: [IBO] yikes! Help!
Author Jason Wharton
> Just made the update with a stored procedure. It looks like that the
> stored procedure doesn't gives that much more speed benefit.
> With the TQuery and CachedUpdates = FALSE and locate, insert/update
> it was 32 sec
> Now with the stored procedurs which handles the insert/update it
> takes 29 sec.

Every little bit counts.

The nicest thing about stored procedures is you now have a hook on the
server you can make adjustments with in a way that the client can remain the

Jason Wharton
CPS - Mesa AZ