Re: slow and fast query problem

2001-08-06 Thread Cal Evans
ssage - From: "Erlend Stromsvik" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 06, 2001 10:53 Subject: slow and fast query problem > Hi > > (I hope I'm not asking to many 'stupid' questions... :) > > This query runs very fast

slow and fast query problem

2001-08-06 Thread Erlend Stromsvik
Hi (I hope I'm not asking to many 'stupid' questions... :) This query runs very fast (time 0.01 seconds): SELECT * from DB_GNIST.varer WHERE kategori = 24010 ORDER BY utgivelses_aar DESC LIMIT 10; This one is slow (time 0.73seconds): SELECT * from DB_GNIST.varer WHERE kategori = '24010' ORDER B