azzbacwordz - 9:25 pm on Feb 21, 2005 (gmt 0)

50,000 may be a overstatement, but that is my goal. I will be hosting multiple sites, but at this time, the site which will be doing most of the querying is a blog hosting site. Basically, it will host users blogs. If you can imagine how many times each individual update their blogs a day, log in and out of the system a day, produce rss feeds, etc.

Not sure if this is a proper question, but do anyone know if MySQL has anything like a cache, so instead of the db accepting queries it can respond to queries from a cache file? Like holding the last 24 hours of db queries within a file that is not aligned with MySQL. Therefore, allow the db to be free to process other information.