| Subject | Re: FOR SELECT .. DO .. UPDATE is slow |
|---|---|
| Author | clementdoss |
| Post date | 2004-07-19T18:44:42Z |
--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...> >
Well.. fetching 7000 records is not the intention. I would like to
update the balance field.
You see, this application was build in paradox (by me), and working
over a network (25 users). Now the pdx tech is old, and a
client/server would be great for them. I am building the application
using FB. I just did a test to calculate the balance of one account.
And the same account, on the same network... well I'm sorry to say,
but my old application kicked the new one butt. And I am using this
stored procedure to calculate. I just don't understand. Is should be
much faster since it all the calculation is done at the server.
Clément
> How many records are there in the table TB_MOV?long
> If you execute the SELECT query by itself(outside of a SP), how
> does it take to execute and fetch all the records?There are less than 100000 records (91700).
>
Well.. fetching 7000 records is not the intention. I would like to
update the balance field.
You see, this application was build in paradox (by me), and working
over a network (25 users). Now the pdx tech is old, and a
client/server would be great for them. I am building the application
using FB. I just did a test to calculate the balance of one account.
And the same account, on the same network... well I'm sorry to say,
but my old application kicked the new one butt. And I am using this
stored procedure to calculate. I just don't understand. Is should be
much faster since it all the calculation is done at the server.
Clément