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]

Reply via email to