Re: Initial Table Access Slowness

2003-09-14 Thread Matt W
Hi John, - Original Message - From: "John May" Sent: Sunday, September 14, 2003 7:52 AM Subject: Initial Table Access Slowness > I'm noticing that if a table hasn't been used in a while, it takes > MySQL considerably longer than normal to do the first access

Initial Table Access Slowness

2003-09-14 Thread John May
I'm noticing that if a table hasn't been used in a while, it takes MySQL considerably longer than normal to do the first access of it. Once that happens, it's back up to speed. Any idea on why this happens? I'm assuming maybe the table file gets closed? Any way to bump up RAM to keep all tabl