|
Deleted
deleted
4116 Posts |
 Posted - 21 March 2003 : 04:43:46
|
Each case may need different design considerations. They depend on:
1) database structure
2) indexes
3) SQL code that is run (Select)
4) expected number of records
5) expected number of hits
6) ..
The test setup is also important of course. The code versions provided is optimized for scalability, which will work better on thousands of records but may work slower if you have a couple records...
It is similar to sorting/searching algorithms. Sometimes it is more efficient not to sort and access the record with linear search, a case for less than ten records...
Without decent tests you would not know which performs better.
|
 Stop the WAR! |
 |
|
Topic Locked
I was about to go out when wrote the message.