Mailing List Archive


Back to the month index Back to the list index
Mark Woolfson (mark@limedia.com)
Tue, 03 Sep 1996 11:47:57 -0400 

Message-Id: <2.2.32.19960903154757.002cd5f4@limedia.com>
Date: Tue, 03 Sep 1996 11:47:57 -0400
From: Mark Woolfson <mark@limedia.com>
Subject: Re: [mSQL] speed of querry

At 03:36 PM 9/2/96 -0500, you wrote:
>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
>
>

Andrew,

What would have to happen is that every record in the table would need to be
read and checked. However, depending on the amount of records in the table,
the size of each record, and your systems H/W specifications, mileage can
vary. There isn't any formula to use either. So you are basically asking
for someone to do the work for you. If someone has #'s to offer, great.
However, I don't know many people who would be so kind.

Mark

=============================================================================
Mark Woolfson
MIS Director
This Week Publications, Inc.
Farmingdale, NY 11735

--------------------------------------------------------------------------
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!