On Thu, Mar 25, 2004 at 11:02:31AM +1200, Sidney Markowitz wrote: > Michael Parker wrote: > >you certainly should run it more than once, I'd say at > >least 3 times with the same data. > > I'm having the machine run through some tests while I'm at work/school. > We'll see what it says. But I did get to see the first additional run > and it was completed in 15 minutes. This may mean that the good result > for adding the SELECT ... token IN ... to the fixed length fields change > has no statistical significance.
Do you have a benchmark script? I think we might want to see test results without tok_get_all change. Making small steps so we can see exactly what performance gains are made. > One thing that I have tried yet is setting the query cache to more than > the default of 0. From your warnings about blowing out the cache, it > seems that I should set it up to, what, 100000 or so? Keep it at 0, my understanding of how the MySQL query cache works is different than I'm used to with Oracle. So it doesn't matter for MySQL. Michael
