If you're WHERE clause uses an index, it should be log(2) times slower for
the actual row selection, but parsing the query, doing JOINs, packaging the
data, etc will all be the same, so the actual time difference will be less
than that.
Cheers,
barneyb
> -----Original Message-----
> From: brobborb [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 06, 2004 12:38 PM
> To: CF-Talk
> Subject: SOT: SQL Query
>
> hey guys, what do u think the performance difference is in MS
> SQL Server 2000....
>
> Querying from a table of 500,000 rows or querying from a
> table of 1 million rows?
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- maxlength for textarea Tony Weeg
- Re: maxlength for textarea Scott Weikert
- RE: maxlength for textarea Douglas.Knudsen
- RE: maxlength for textarea Tangorre, Michael
- RE: maxlength for textarea Tony Weeg
- RE: maxlength for textarea Kenneth Wilson
- Re: maxlength for textarea Bryan Stevenson
- SOT: SQL Query brobborb
- Re: SOT: SQL Query Dick Applebaum
- RE: SQL Query Barney Boisvert
- RE: SQL Query Barney Boisvert
- RE: SQL Query Paul Kenney
- Re: SQL Query brobborb
- RE: SQL Query Tony Weeg
- Re: SQL Query brobborb
- RE: SQL Query Tony Weeg
- RE: SQL Query Barney Boisvert
- RE: SQL Query Jochem van Dieten
- RE: SQL Query Tony Weeg
- Re: SOT: SQL Query Claude Schneegans