At 10:33 AM 4/25/2014, [email protected] wrote:
I have an issue on timing. I have two tables, one holds daily
transactions and the second holds customer orders. The daily
transaction table could hold from 10 to 500 records. The
customer order table holds approx. 40,000 records.I am just
reading a daily transaction, looking it up by order number and
updating the processed date I the customer Order table.
In testing I found the following results: If I key an update
it is complete in just a second. If the daiily table has 5
records it takes approx. 4 1/2 seconds per record to process.
5 records take 4.5 seconds per record,
10 records take 8 seconds per record,
20 records take 15 seconds per record,
30 records take 24 seconds per record.
Why the increment in processing time, any suggestions?
Angelo,
It all depends on the technique to update records using the
DECLARE, FETCH, and the WHILE ... ENDWHILE.
Without knowing all details ...
The proper use of indexing can greatly increase the speed of your
applications. The suggestions for using indexes may provide you
with a significant performance boost, though incorrect indexing
can adversely affect the speed of your applications.
Here's an article that explains it all ...
From The Edge: http://www.razzak.com/fte/
Topic: Indexing Explained
Hope that helps!
Very Best R:egards,
Razzak.
www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--
