Home » RDBMS Server » Server Administration » very slow query
very slow query [message #374744] Thu, 28 June 2001 03:14 Go to next message
Konstantin
Messages: 6
Registered: June 2001
Junior Member
I have a table which includes 78 fields. I have a query : "select * from this_table where id=X" which I call from perl application. After I load about 40000 rows into this table, this query runs very slow. How can I fix it?

Thanks.

Report message to a moderator

Re: very slow query [message #374746 is a reply to message #374744] Thu, 28 June 2001 05:10 Go to previous message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
If it is a join, place the table having lots of rows at the end of the FROM-clause. Make some index of the primary keys.

Report message to a moderator

Previous Topic: How to get the abstract data type values
Next Topic: Creating an Instance
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 04:19:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.