Welcome Guest, Not a member yet? Register   Sign In
database caching error with query using LIKE
#2

[eluser]dardar[/eluser]
I found, what only one query is causing error (with caching disabled everything works nice):

Code:
SELECT distinct (artist.name), artist.id FROM artist RIGHT JOIN track ON artist.id=track.artist WHERE artist.name LIKE 'g%' ORDER BY artist.name LIMIT 10

This table is quite large (~ 1 million rows), but there are only 10 results, so is there any fix?


Messages In This Thread
database caching error with query using LIKE - by El Forum - 10-19-2007, 04:27 AM
database caching error with query using LIKE - by El Forum - 10-21-2007, 07:10 PM



Theme © iAndrew 2016 - Forum software by © MyBB