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?
If I key an update
