The amount of data doesn't affect how long it takes the appadmin home page
to load, as no data are being pulled from the database at that point. Even
when you do select a specific table, it only loads the first 100 records,
so again, nothing should hang.
Note, defining the model of the table (as in your code below) doesn't
actually pull any of the data from the database -- it just tells web2py
about the structure of the database table so it knows how to make selects,
updates, inserts, etc.
Anthony
On Tuesday, February 18, 2014 11:15:06 AM UTC-5, John Philip wrote:
>
> 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.
