Hi there,
I am trying to access a mysql database table with a very large amount of
data.
dbsql = DAL('mysql://myusername:mypasswrd@host/dbname', migrate=False)
dbsql.define_table('evth',
Field('datetime', 'integer'),
Field('eventid','text'),
Field('stream','integer'),
Field('application','text'),
Field('workstation','text'),
Field('severity','text'),
Field('type','text'),
Field('message','text'),
primarykey=['datetime'])
In theory this should work. However when I run the database administration
button to create the models it seems to hang. I suspect because of the
amount of data. Since I am only interested in the most recent data is there
anyway of doing this without web2py having to model the entire table?
any help would be much appreciated.
many thanks and regards,
John
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
