The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

SQL question


  • Subject: SQL question
  • From: James Traynor
  • Date: Sat, 08 May 2004 23:53:00 +0000

I am running some queries on the tables created by the xapdblogger
(mysql) and have come across an oddity that there is probably a really
simple explanation to.


select header_id from messageheader where
source="mi4.weather.egll"
order by header_id desc limit 1;

takes 9 seconds

select header_id from messageheader where source='mi4.weather.egll'
order by header_id desc limit 1;

takes .05 seconds

what does the " do that the ' doesn't ??

Thanks

James







xAP_Development Main Index | xAP_Development Thread Index | xAP_Development Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.