Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > postgresql > answers

How to speed up a query

Newbie
  
Join Date: Aug 2007
Posts: 1
#1: Aug 30 '07
Hai all.
Having a table with above 50,000 rows. Also this table having a field date . I want to select latest 50 records. But if use order by desc clause it wil take more time to process . Is there any simple query for speed up the select process. Urgent . Any one plz help me.
Moderator
  
Join Date: Nov 2006
Location: Boston, USA
Posts: 505
#2: Aug 30 '07

re: How to speed up a query

Do you have an index on this field?
Reply

« previous question | next question »

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,223 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved