Hi there,
I have a huge querry which takes for ever on a table containing only 2000
records.
Maybe there is a way to reorganize this querry since it contains a join and
lots of other stuff I am not really familar with.
Let me first show you the sql query:
SELECT DISTINCT
u.user_id,
[snip]
SELECT DISTINCT
u.user_id,
u.user_name,
max(
if(u.sex=2,25,0) +
if(u.age=4,25,0) +
if(u.country='gm',25,0)+
if(l.language_id='de',25,0)
)
AS ranking,
c.country_code,
c.country,
ct.city,
PROTECTED]
Sent: Thursday, May 16, 2002 3:25 PM
Subject: RE: Speeding up a huge sql query
[snip]
SELECT DISTINCT
u.user_id,
u.user_name,
max(
if(u.sex=2,25,0) +
if(u.age=4,25,0) +
if(u.country='gm',25,0)+
if(l.language_id='de',25,0