PDA

View Full Version : Can CACHE_INDEX help speed up vb?


dwh
01-21-2005, 10:00 AM
If my forum is any indication, the post index takes up about 10% of the space as the actual data does. I'm wondering if a MySQL pro might look at this: http://dev.mysql.com/doc/mysql/en/CACHE_INDEX.html
I bet if your system has the resources for it, sticking the post index into a cache should speed up the system considerably.

Andreas
01-21-2005, 10:20 AM
By default, table indexes are assigned to the main (default) key cache created at the server startup.
Hmm ... doesn't sound as this would help.