MySQL
The reason it is char(9) fields is because I wrote my own import app
(Delphi 6) that writes directly to my "myd" file.
I can import 106 million records from a Fixed Field with text file
in 45 Minutes.
Then I ran "myisamcheck -r -q experian" to regenerate the indexes.
mike...
-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 12:20 PM
To: Mike Grover
Subject: Re: RE: RE: mySQL vs Interbase
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To
On Thu, Jan 10, 2002 at 10:25:55AM -0600, Mike Grover wrote:
>
> I have a database in Firebird(Interbase) that has 106 million
> records at 37.4 gig.
>
> I imported the database into mySQL and built the same indexes.
>
> with a query like this:
>
> select * from experian.experian where latitude
erian.experian
where latitude between '038631928' and '038638092'
and longitude between '096671646' and '096680757'
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 10, 2002 12:09 PM
> To: Mike
In the last episode (Jan 10), Mike Grover said:
> select * from experian.experian where latitude >= '038631928' and
> latitude <= '038638092' and longitude >= '096671646' and longitude <=
> '096680757';
>
> Interbase takes 10 seconds to return 70 records, but mySQL takes 18 seconds
> to return t
AIL PROTECTED]]
Sent: Thursday, January 10, 2002 10:08 AM
To: Mike Grover
Subject: Re: mySQL vs Interbase
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your mes
At 15.40 29/11/01 -0500, Raymond Abel wrote:
>At 16:44 2001-11-29 +, you wrote:
>>On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
>>
>> > > I saw somewhere that this comparaison existed but I can't remember
>> > > where.
>> > > Does it talk to anyone ?
i used interbase to develop an applicat
At 16:44 2001-11-29 +, you wrote:
>On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
>
> > > I saw somewhere that this comparaison existed but I can't remember
> > > where.
> > > Does it talk to anyone ?
I am a 2 weeks old newbee
I did try interbase because it came with staroffice 5.2
never
Why are you sending email to me.
-Messaggio originale-
Da: Gordan Bobic [mailto:[EMAIL PROTECTED]]
Inviato: giovedì 29 novembre 2001 17.45
A: Fabien R.; [EMAIL PROTECTED]
Oggetto: Re: mySql vs Interbase
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
> > I saw somewhere tha
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
> > I saw somewhere that this comparaison existed but I can't remember
> > where.
> > Does it talk to anyone ?
I haven't seen one between InterBase and MySQL, but I do remember seeing one
between PostgreSQL and InterBase. Allegedly, they thought
>
>
> Hello,
> I saw somewhere that this comparaison existed but I can't remember
> where.
> Does it talk to anyone ?
>
> TIA,
> Fabien
(mysql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
11 matches
Mail list logo