Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Returning unique values in one column
Hi, Thanks for that it works perfectly! Unfortunately it takes about 22 minutes for the query to run! :-( I currently have 2.8 million rows in the table and that could easily double. Can anyone give me some pointers on how I could reduce this time or an I asking a bit much of mySQL here... -
Returning unique values in one column
Hi, I currently have a table called “pages” containing the following columns: pageid, domainid, location, lastread I've put together a query that returns 10 rows with the lowest “lastread” values, for which this works fine: SELECT * FROM pages ORDER BY lastread ACS LIMIT 0,10; I now the have... -
Returning unique values in one column
Hi, I currently have a table called “pages” containing the following columns: pageid, domainid, location, lastread I've put together a query that returns 10 rows with the lowest “lastread” values, for which this works fine: SELECT * FROM pages ORDER BY lastread ACS LIMIT 10; I now the have...- neil6179
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
