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

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com