Thanks for the quick reply. I need some further inputs from you. Is there any other way (except query cache) using which the database can be made memory resident. Actually I want a database which is to be used by a lookup server(something like a dns server). The database lookup delay can become a bottleneck in the performance of the server. Do you know of any techniques used to speedup frequent database lookups for databases which are mostly static in nature.
thanks and regards, Chetan -----Original Message----- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 22, 2002 12:41 PM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: regarding the MySQL's server Chaching feature On Tue, Jan 22, 2002 at 12:30:56PM +0530, Chetan Lavti wrote: > > I am using (open source) MySQL-3.23.47, I wanted to know, is the > feature of caching of the data in RAM is available in this version > ?If yes , then what is the limit of that in terms of size. What I > have Understood is that this feature will be available with the > version 4.0 and if so, how this is implemented in the version 4.0 > ?how to configure this ? It sounds like you're referring to the new Query Cache. If so, no. That's in verison 4.0 only. -- 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 19 days, processed 440,853,176 queries (264/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
