Thanks for the insight. --jeff
----- Original Message ----- From: "Mike Grover" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:07 AM Subject: RE: Best book on MySQL > 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 > --------------------------------------------------------------------- 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
