Mailing List Archive


Back to the month index Back to the list index
Andrew Moroz (focalnet@focal.net)
Mon, 2 Sep 1996 15:36:19 -0500 

Message-Id: <v02140b01ae50f46f66db@[144.92.180.195]>
Date: Mon, 2 Sep 1996 15:36:19 -0500
From: focalnet@focal.net (Andrew Moroz)
Subject: [mSQL] speed of querry

Hi,

Here is my question:

I have a table with 10 or so fields, all about 40 in length, mostly chars
with a couple of ints. One of them is a primary key. I have in it x
records.

Can somebody tell me what the speed loss would be for a range of x values
if i was to do a simple select by one of the non-primary fields.

What I'm looking for is like this (but more detailed if possible):

Records Seconds
-----------------------
100 a
1000 b
10000 c

Thank you!

/--------------------------------------------------\
| FocalNet Web Design |
| |
| Professional Web Site design, implementation |
| and hosting, at affordable rates. |
| |
| Andrew Moroz -- info@focal.net |
| http://www.focal.net |
\--------------------------------------------------/

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!