Re: Fw: 2 questions about indexing and testing speed

2003-06-10 Thread rich johnson
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote: > I'm learning MySQL and I got two question: > > 1) As I know, MySQL has a buffer to keep the last records which have been retreived. So if I run a query two times, the second time will be faster. How can I temporarly stop this service? because I want

Re: Fw: 2 questions about indexing and testing speed

2003-06-10 Thread Victoria Reznichenko
"Mojtaba Faridzad" <[EMAIL PROTECTED]> wrote: > I'm learning MySQL and I got two question: > > 1) As I know, MySQL has a buffer to keep the last records which have been retreived. > So if I run a query two times, the second time will be faster. How can I temporarly > stop this service? because I

Fw: 2 questions about indexing and testing speed

2003-06-09 Thread Mojtaba Faridzad
Hi, I'm learning MySQL and I got two question: 1) As I know, MySQL has a buffer to keep the last records which have been retreived. So if I run a query two times, the second time will be faster. How can I temporarly stop this service? because I want to run different queries and compare their sp

FW: 2 questions!

2001-01-15 Thread Anthony Cooke
From: Anthony Cooke <[EMAIL PROTECTED]> Date: Mon, 15 Jan 2001 10:33:05 -0400 To: Arthur Radulescu <[EMAIL PROTECTED]> Subject: Re: 2 questions! Two answers! 1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let the file system cache image files, store only the file name.