web2py[:]


If you benefit from web2py hope you feel encouraged to pay it forward by contributing back to society in whatever form you choose!


  • 0
    hillmanov  14 years ago
    Getting better! Would it be possible to eliminate the last three SELECT statements, since the data is obtained using the first SELECT? I think this might eliminate the extra network traffic and processing time. Wireshark capture: 
    SET FOREIGN_KEY_CHECKS=1;
SET sql_mode='NO_BACKSLASH_ESCAPES';
SELECT allstats.id, allstats.pdate, allstats.parameter, allstats.peaktime FROM allstats WHERE allstats.id>48000 LIMIT 100 OFFSET 100;
SELECT count(*) FROM allstats WHERE allstats.id>48000;
SELECT allstats.id, allstats.id FROM allstats WHERE allstats.id>0;
SELECT allstats.id, allstats.pdate FROM allstats WHERE allstats.id>0;
SELECT allstats.id, allstats.parameter FROM allstats WHERE allstats.id>0;
SELECT allstats.id, allstats.peaktime FROM allstats WHERE allstats.id>0;
commit

Commented on:

WebGrid for web2py
Recipe by Nathan Freeze (mrfreeze) on 2009-12-04 in Module
This is a module that lets you build a table on the server that supports paging, sorting, editing and totals easily. It requires no javascript or sessions to work.
Hosting graciously provided by:
Python Anywhere