Brian Neu wrote:
> It's the "BETWEEN" construct, or what it does rather.
> 
> "AND message_idnr >= 253775 AND message_idnr <= 253775"  did the same thing.
> 
> "message_idnr = 253775" brought a 70ms query, instead of 7+ seconds.
> 
> Sooo . . . . . . . ummmm.  What would people that are smarter than me in this 
> arena suggest that I do about this?  Obviously someone chose a range for a 
> reason.

I'll fix this before 2.2.6



-- 
  ________________________________________________________________
  Paul Stevens                                      paul at nfg.nl
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to