Re: [sqlite] Performance analysis of SQLite statements

2007-04-13 Thread Nuno Lucas
On 4/12/07, Brandon, Nicholas (UK) <[EMAIL PROTECTED]> wrote: > > You used to be able to compile with -DVDBE_PROFILE=1 to enable some > > special assembly-language instructions that would use > hi-res timers on > > ix586 chips to provide the cycle counts needed to execute each > > instruction in

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread John Stanton
What do you want to measure? Jonas Sandman wrote: Anyone know a good bench-marking (preferably free or cheap) which can be used to benchmark C/C++ code in Windows? Best regards, Jonas On 4/12/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: Are there any tools to help analyze the performance

RE: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Brandon, Nicholas \(UK\)
> > You used to be able to compile with -DVDBE_PROFILE=1 to enable some > > special assembly-language instructions that would use > hi-res timers on > > ix586 chips to provide the cycle counts needed to execute each > > instruction in a VDBE program. But I haven't used that feature in >

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Dennis Cote
Jonas Sandman wrote: Anyone know a good bench-marking (preferably free or cheap) which can be used to benchmark C/C++ code in Windows? It's not free, but AQTime http://www.automatedqa.com/products/aqtime/ from AutomatedQA is quite good and supports most compilers under windows. You can

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Nuno Lucas
On 4/12/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: You used to be able to compile with -DVDBE_PROFILE=1 to enable some special assembly-language instructions that would use hi-res timers on ix586 chips to provide the cycle counts needed to execute each instruction in a VDBE program. But I

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Jonas Sandman
Anyone know a good bench-marking (preferably free or cheap) which can be used to benchmark C/C++ code in Windows? Best regards, Jonas On 4/12/07, Samuel R. Neff <[EMAIL PROTECTED]> wrote: Are there any tools to help analyze the performance of components with a particular SQLite statement?

[sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Samuel R. Neff
Are there any tools to help analyze the performance of components with a particular SQLite statement? I'm aware of the EXPLAIN option which can show what VBDE code was used to execute a statement, but afaik there is no way to tell the time each step took. Basically I want to know how long the