I belive the type of table you use here will be the only thing that will speed things up. If you use MyISAM tables and have 100's of users calling things from the DB and 100's of users INSERTING things into the same table, then it will be very slow due to MyISAM's table level locking. Using InnoDB tables will speed up access time due to ROW level locking.
-My 2c --------------------- Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -----Original Message----- From: BD [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 9:42 AM To: [EMAIL PROTECTED] Subject: Re: Which is faster VarChar(255) or Text? At 02:31 AM 1/25/2002 , you wrote: >On Thu, Jan 24, 2002 at 05:27:18PM -0600, BD wrote: > > > I will be putting variable length text into a field (up to 255 > > characters but typically around 60 characters) and wonder what makes > > for faster retrieval? Or does it matter? A field defined as > > Varchar(255) or Text? > >Do you mean VARCHAR(255) or TINYTEXT? > >As seen here: > > http://www.mysql.com/doc/n/o/node_366.html > >TEXT columns can be much larger than 255. But they require an extra >byte for the length portion of the record. So VARCHAR(255) will be >ever so slightly faster than TEXT. > >Jeremy Jeremy, Thanks, I hadn't thought of TinyText. With flat file type databases that I used to use, if I put something in a memo field, it takes longer to retrieve the data because it is stored in a separate physical file. There is a noticeable lag on slow machines. I was wondering if using a Text (or TinyText) in MySQL exhibited noticeably slower record retrieval when hundreds of users are querying the database. Or is it too small to notice? Brent >-- >Jeremy D. Zawodny, <[EMAIL PROTECTED]> >Technical Yahoo - Yahoo Finance >Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > >MySQL 3.23.41-max: up 22 days, processed 514,632,289 queries (266/sec. avg) > >--------------------------------------------------------------------- >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
