Tag Archives: mysql

AltSQL

AltSQL. AltSQL is a way to improve your user experience with mysql, sqlite3, psql and other tools that Perl has DBI drivers for. Currently written for MySQL only, the long term goal of this project is to provide users of … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

MySQL and subselects

Why does this query (on a small indexed table with ~3000 rows) take almost a minute to return select client,  unix_timestamp() – unix_timestamp(hittime) as timediff from polling where id in (select max(id) from polling where system=’$system’ group by client) and … Continue reading

Posted in Linux | Tagged , , | Leave a comment