Mainly what hooked me on mySQL was the static record layout for MyISAM tables.
I have to import into new tables about 120 million records every three months. I wrote a Quick Delphi 6 app to do this(very fast). Once I figured out how the byte header for deleted and null Fields work at the beginning of each MyIsam row, I now Can also use null field checking in my queries. ( I suck out important fields from a 1100 byte fixed row record text file into a 379 byte MyISAM row that goes directly into the myd file. Run "myisamchk -r -q v:\data\experian\ca" and my Indexes are rebuilt :-) ) I then Optimize these tables, and mySQL speed is Awsome... -----Original Message----- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:33 PM To: Michael Grover; [EMAIL PROTECTED] Subject: Re: Best book on MySQL Hi Mike, What did you think of Firebird vs. MySQL? I haven't seen any comparisons by people who have used both. Thanks, --jeff ----- Original Message ----- From: "Michael Grover" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, May 11, 2002 7:25 PM Subject: Re: Best book on MySQL > > I ported several applications from Firebird 1.0 to MySQL 4. The main > things I ran into was little SQL Syntax differences, Stored > procedures, and Triggers... > > > mike > > Paul DuBois wrote: > > > > At 13:40 -0700 5/11/02, Jeff Kilbride wrote: > > >MySQL > > >Paul DuBois > > >New Riders > > > > > >Plus, he's here on the list answering questions... :) > > > > That's true. > > > > However, I should mention that the book doesn't say anything about > > InterBase. :-) > > > > >--jeff > > > > > >----- Original Message ----- > > >From: "Todd Cary" <[EMAIL PROTECTED]> > > >To: <[EMAIL PROTECTED]> > > >Sent: Saturday, May 11, 2002 8:43 AM > > >Subject: Best book on MySQL > > > > > > > > >> I need to convert a PHP app from using Interbase to using MySQL. What is > > >the > > >> best book? > > >> > > >> Todd > > >> > > >> -- > > >> Todd Cary > > >> Ariste Software > > >> 2200 D Street Extension > > >> Petaluma, CA 94952 > > >> 707-773-4523 > > > > [EMAIL PROTECTED] > > > > -------------------------------------------------------------------- > > - > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > > http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
