Thread: Optimization problem?
Re-Hello, I'm working with a table with about 650'000 rows. It's working pretty well, my queries take about 20 seconds. I would like to know to optimize it ? Jérôme Knöbl
On Tue, 1 Sep 1998, Jerome Knobl wrote: // I'm working with a table with about 650'000 rows. It's working // pretty well, my queries take about 20 seconds. // // I would like to know to optimize it ? Given the information provided, I'd recommend buying a SQL book. You also might want to add an index or two (the SQL book would tell you all about it). -- SA, software.net My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net> | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE L_______________________ I hope the answer won't upset her. ____________
I add some index (hash table), that why my queries take about 20 seconds (I try with index, and I stop the process after 1 hour). JK dustin sallings wrote: > On Tue, 1 Sep 1998, Jerome Knobl wrote: > > // I'm working with a table with about 650'000 rows. It's working > // pretty well, my queries take about 20 seconds. > // > // I would like to know to optimize it ? > > Given the information provided, I'd recommend buying a SQL book. > You also might want to add an index or two (the SQL book would tell you > all about it). > > -- > SA, software.net My girlfriend asked me which one I like better. > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net> > | Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE > L_______________________ I hope the answer won't upset her. ____________