I have a table with a huge amount of records. There are aprox 3*10^6
registers and counting.
I need via scheduler delete the older registers, but the criteria of old
register is determined by a datetime field:
db.define_table('foo',
Field('foo_file', 'upload', required=True, notnull=True,
autodelete=True, uploadseparate=True),
Field('foo_date', 'datetime', notnull=True))
Unfortunately there is no relation between id and date (the user/system
could put data older than the current date).
The system has a controller which shows the lasts 10 registers with the
indicated criteria. But the query takes too much time, more than 7
seconds just the query. I have also a periodically task archiving the
older registers.
rows = db().select( orderby=~db.foo.foo_date, limitby=(0, 10))
I need a way in the DAL for indicating the foo_time datefile field
should be indexed or similar in order to get fastest queries! :/ I am
using mysql.
Thanks in advance.
--
.::MAbeeTT::.
mabeett [at] gmail [ dot] com
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
