This is a Win2k Server Service pack2

Proably about 4 connections at most at one time.

But the database will be big.

I did figure out last night playing with a 5 million record database
that with a Query statement like this

SELECT * FROM EXPERIAN WHERE LATITUDE BETWEEN '036232356' AND '036232746' AND
LONGITUDE BETWEEN '09674637495' AND '09674637725'

It needs to be indexed like this

CREATE INDEX LATITUDE ON EXPERIAN (LATITUDE);
CREATE INDEX LONGITUDE ON EXPERIAN (LONGITUDE);


if any body can think of a way to create a better index for this type of query, please let me know

mike...

-----Original Message-----
From: Leyne, Sean [mailto:InterbaseSupport@...]
Sent: Tuesday, August 14, 2001 10:10 AM
To: 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] Re: Importing Records


Mike,

Are you running on NT/Win2000 or Linux?

How many concurrent database connections are you expecting?


Sean

> -----Original Message-----
> From: Mike Grover [mailto:mike@...]
> Sent: Tuesday, August 14, 2001 11:13 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Re: Importing Records
>
>
> Ok, Well I have a question?
>
> I have been programming since 1976, but I have never used Interbase
> before.
>
> What is better on the Firebird page?
>
> Classic or super server?
>
> What is the diff?
>
> Server will be running on a Dual PIII 800 mhz machine.
>
> 1 gig of ram
>
> mike...
>
> -----Original Message-----
> From: Alexander V.Nevsky [mailto:alex_vnru@...]
> Sent: Tuesday, August 14, 2001 9:45 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: Importing Records
>
>
> --- In ib-support@y..., "Mike Grover" <mike@l...> wrote:
>
> > Is anybody else here using firebird?
>
> Hi, Mike. I hope it's more easy to count who don't use
> Firebird here
> :))) We (Bereg Ltd, largest paper trader in Russia) run on Firebird
> database with ~ 600 tables, 600 SP, 1200 triggers, 2000 indexes since
> 01.01.2001.
>
> Best regards.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/