Sql Speed Testing Program

[hind_0a0]

Hello Brothers

I Have Very Complicated Sql Statements And I Need To Test Them

To Know How Its Execution Speed So Do U Know Any Program To Test These Query.


Thanks.

[f_eriksen]

if you are using ms sql, then a simple trace in profiler should do it.

[hind_0a0]

Thank U For Reply

No I Am Not Using Ms Sql
My Database Is Ms Access But I Can Work In Oracle

So Any Application Than Tests Sql Queries For Its Execution Time

Because I Do Not Want To Use Query That Very Slow In Execution
Cause I Have More Than 3000 Records In The Database So Query Should Be Fast To Retrive Data .
So Please Tell Me The Link Or The Name Of An Application That Test Queries For Execution Time.


Than U.

[f_eriksen]

well, in access you are pretty limited in terms of tracing, io stats etc...

what you could do however, is build a simple module, modTest, create a simple sub in it, that takes an arbitrary sql statement, records the time of start in a variable, open a connection to currentproject.connection (i think it is called), execute the sql, record time end in a 2nd variable, make a quick diff from the first timestamp, and record it in a local table or something.

faaaaar from perfect, but I fear your choices are limited within access.

AFAIK, nothing ready made exists (but I am by no means an expert in that field so..)

sorry.