-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi!
I guess you're not a subscriber of the MySQL Newsletter. Subscribe to it - it's very useful! Your question was answered a couple of days ago in ta newsletter article: http://www.mysql.com/newsletter/2002-12/a0000000091.html Regards, Iikka On Thu, 19 Dec 2002, Richard E. Perlotto II wrote: > I am looking at an application that will be could be potentially > writing hundreds of records a second (syslog) to a MySQL database. > I expect to reach millions of records (if not billions) in time. > > I will be doing a variety of types of queries on the data which > will be anything from summarization of certain types of data to > full pattern matching. > > So, my question is which of the database formats would be best > suited for this type of environment? The MyISAM seem to work > well on receiving the data, but the InnoDB database style seems > better suited for the queries. > > Any ideas anyone? > > > Richard > > > > --------------------------------------------------------------------- > 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 > ======================================== Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE+AjNPCVGYZ+r4ZncRAvVOAJ4pswyFWizkCnSbHOv47HQmSip7hACbBiWT qzLWClrkqxVCroVNrp3Ob1o= =eIxR -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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