Welcome to WebmasterWorld Guest from 3.80.6.254

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Echo Distinct?

     
4:43 pm on Jun 2, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Nov 29, 2003
posts:94
votes: 0


Hi,

Any suggestions on speeding up a distinct?

each row in mysql has say one character in it a or b or j or r or 6 etc, im trying to retrieve distinct but its very slow, i have used group by which returns in the correct order but is still slow.

Goal, if the table has an "a" in it i want to echo a link to "a" but not hundreds of them, just one.

If the rows has no "a" it wont echo a link.

Its an A-Z links index i want but i dont want links to pages that have no reuslts,

im poor explaining but hope someone can help
Thankyou

5:44 pm on June 2, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Feb 29, 2004
posts:194
votes: 0


Try indexing the field that you are searching. It should help speed things up.
6:29 am on June 3, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Nov 29, 2003
posts:94
votes: 0


Thanks, already indexed but still slow as over 100k rows.