Re: Advice on where to go next in profiling a query

2001-04-07 Thread Roel Vanhout
There is an option long_query_time that you can use to log query that take longer then a preset time, if that's of any help. cheers, roel On Sat, Apr 07, 2001 at 02:05:13PM +0100, Ewan Birney wrote: > > > We are very happy users of MySQL, which we run a nice big genome database > on. We hav

Advice on where to go next in profiling a query

2001-04-07 Thread Ewan Birney
We are very happy users of MySQL, which we run a nice big genome database on. We have a web front end to the database (www.ensembl.org if anyone is interested) and we are looking at getting our pages to come back faster. I have been moving things out of Perl into C for the heavier lifting betw