MySQL vs Interbase

2002-01-10 Thread Mike Grover
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... -

RE: RE: RE: mySQL vs Interbase

2002-01-10 Thread Mike Grover
-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

Re: mySQL vs Interbase

2002-01-10 Thread Jeremy Zawodny
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

RE: mySQL vs Interbase

2002-01-10 Thread Nally, Tyler G.
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

Re: mySQL vs Interbase

2002-01-10 Thread Dan Nelson
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

RE: mySQL vs Interbase

2002-01-10 Thread Mike Grover
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

Re: mySql vs Interbase

2001-11-30 Thread Ivano Luberti
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

Re: mySql vs Interbase

2001-11-29 Thread Raymond Abel
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

R: mySql vs Interbase

2001-11-29 Thread M.Travagli
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

Re: mySql vs Interbase

2001-11-29 Thread Gordan Bobic
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

mySql vs Interbase

2001-11-29 Thread Fabien R.
> > > 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