Okay from the two process the fetching is fine, but the updating is slow as
you have stated.
What is the size of the database for these test scenario's. With a clean
database is the speed acceptable ?

How many foreign key's are on the table ?

Thanks

At 10:48 04/12/2003 +0200, you wrote:

>At 10:34 AM 04/12/2003 +0200, you wrote:
>
> >You say that there is more than one procedure to do this process, gathering
> >the data and then updating ?
> >Is it not possible to do the whole process in one stored procedure ?
>
>Unfortunately not. It would have been possible if we were developing the
>application from scratch; but it would require very major changes to the
>POS objects.
>
>
>
>Regards
>
>Tim
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003


[Non-text portions of this message have been removed]