Package: gammu
Version: 1.20.0-1
Severity: important
Hi!
While debugging why gammu takes ages with mysql backend to send a
simple sms I stumbled upon something that made me feel highly
uncomfortable about it. The (my)sql support lacks of all sql basics,
like using indexes in the tables, usage of autoincrement fields for IDs
or at least the max() function instead of ORDER BY ID DESC LIMIT 1.
Pretty please do NOT loop with "while (true)" over a "SELECT ID FROM
sentitems WHERE ID='%i'" when it actually only really wants to know the
largest unused ID ...
I just checked, it's the same horror function in s_pgsql.c ... These
are SQL basics and performance killers, when one has sent about 2000
SMSes (which isn't that much, is it?) it starts to lag behing quite a
lot through the repeated loop, starting to take minutes instead of not
even a few seconds for sending a simple text message ...
Thanks anyway.
Rhonda
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
