[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-20 Thread John Philip
Hi Derek and Anthony, I am not sure what else could cause this. You are right about the modeling. I did change the fields correctly and even recreated the exact table on a localhost mysql db and it worked!! However when I make the connection to the remote database Web2py just hangs. Also what's

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-19 Thread Derek
I doubt that the name of it is an issue. datetime is not in the reserved list. http://web2py.com/examples/static/epydoc/web2py.gluon.reserved_sql_keywords-pysrc.html your modeling of the database could be better. Why are you saying that datetime is an int, when it's actually a decimal? On Wedn

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-19 Thread John Philip
Hi Anthony, thanks very much for your reply. I am able to now create the models ok. However when selecting specific tables in the mysql database web2py seems to hang. What I don't understand is that web2py seems to hang for tables using a field name 'datetime' which is a decimal(13,0) UN PK. Co

[web2py] Re: creating a model of a table (with a large amount of data) in a mysql db. is taking a very long time

2014-02-18 Thread Anthony
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 (a