Click here to Skip to main content
15,920,217 members
Home / Discussions / C#
   

C#

 
Questionselect from DataBase Pin
Thaer Hamael27-Jul-07 18:10
Thaer Hamael27-Jul-07 18:10 
AnswerRe: select from DataBase Pin
Christian Graus27-Jul-07 18:24
protectorChristian Graus27-Jul-07 18:24 
AnswerRe: select from DataBase Pin
Paul Conrad27-Jul-07 19:44
professionalPaul Conrad27-Jul-07 19:44 
QuestionSelecte max(Feild)from Pin
Thaer Hamael27-Jul-07 17:58
Thaer Hamael27-Jul-07 17:58 
AnswerRe: Selecte max(Feild)from Pin
Paul Conrad27-Jul-07 19:44
professionalPaul Conrad27-Jul-07 19:44 
QuestionPointers Performance Pin
Leslie Sanford27-Jul-07 16:53
Leslie Sanford27-Jul-07 16:53 
AnswerRe: Pointers Performance Pin
J. Dunlap27-Jul-07 17:37
J. Dunlap27-Jul-07 17:37 
AnswerRe: Pointers Performance Pin
Luc Pattyn27-Jul-07 17:50
sitebuilderLuc Pattyn27-Jul-07 17:50 
Leslie Sanford wrote:
Any thoughts or insights?


I like open questions... they indicate wisdom: either awareness of ignorance,
or a truely open mind! Smile | :)


In my experience measuring performance by looking at elapsed time is very good
if some precautions have been taken:

1.
the time must be long enough to average out some statistical disturbances, typically
things the system may do in the background; that's disk accesses, Ethernet
packets, anti-virus, whatever. I would suggest to increase the job tenfold.

2.
Be careful with the special situation for the first experiment: if your tests
share something (such as an array), it will not have been allocated in physical
memory, it will not yet have been (partially) loaded in level3 or L2 cache, etc.

Quite often, when comparing two alternatives, the second wins, not because
it is faster, but just because it gets the better starting conditions.

So the minimum one should do is swap both to see how much of a difference that
gives.

My approach to cover both issues typically is to perform all N different tests
one after another, but then loop over it for say 100 times.
Then either ignore the first iteration entirely, and/or do some statistical
analysis on those N result arrays.

But even then, for N>2 the order of the tests may also be significant, so it
might be better to sequence them at random.

Hope this helps.


GeneralRe: Pointers Performance Pin
Leslie Sanford27-Jul-07 18:39
Leslie Sanford27-Jul-07 18:39 
AnswerRe: Pointers Performance Pin
Guffa27-Jul-07 22:13
Guffa27-Jul-07 22:13 
GeneralRe: Pointers Performance Pin
Leslie Sanford28-Jul-07 5:27
Leslie Sanford28-Jul-07 5:27 
GeneralRe: Pointers Performance [modified] Pin
Robert Surtees28-Jul-07 6:34
Robert Surtees28-Jul-07 6:34 
GeneralRe: Pointers Performance Pin
Leslie Sanford28-Jul-07 7:55
Leslie Sanford28-Jul-07 7:55 
GeneralRe: Pointers Performance Pin
Guffa28-Jul-07 9:33
Guffa28-Jul-07 9:33 
GeneralRe: Pointers Performance Pin
Robert Surtees28-Jul-07 10:58
Robert Surtees28-Jul-07 10:58 
AnswerRe: Pointers Performance Pin
Guffa28-Jul-07 13:37
Guffa28-Jul-07 13:37 
AnswerMessage formatting question (expires on sunday) Pin
Luc Pattyn27-Jul-07 23:34
sitebuilderLuc Pattyn27-Jul-07 23:34 
GeneralRe: Message formatting question (expires on sunday) Pin
Leslie Sanford28-Jul-07 5:35
Leslie Sanford28-Jul-07 5:35 
GeneralRe: Message formatting question (expires on sunday) Pin
Luc Pattyn28-Jul-07 5:44
sitebuilderLuc Pattyn28-Jul-07 5:44 
GeneralRe: Message formatting question (expires on sunday) Pin
Leslie Sanford28-Jul-07 5:46
Leslie Sanford28-Jul-07 5:46 
GeneralRe: Message formatting question (expires on sunday) Pin
Luc Pattyn28-Jul-07 5:54
sitebuilderLuc Pattyn28-Jul-07 5:54 
GeneralRe: Message formatting question (expires on sunday) Pin
Leslie Sanford28-Jul-07 6:18
Leslie Sanford28-Jul-07 6:18 
GeneralRe: Message formatting question (expires on sunday) Pin
Luc Pattyn28-Jul-07 7:15
sitebuilderLuc Pattyn28-Jul-07 7:15 
QuestionInterActive javaScripte With Combobox html control Pin
Thaer Hamael27-Jul-07 15:53
Thaer Hamael27-Jul-07 15:53 
AnswerRe: InterActive javaScripte With Combobox html control Pin
Christian Graus27-Jul-07 16:54
protectorChristian Graus27-Jul-07 16:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.