[web2py] Re: export-table timeout?

2013-03-15 Thread Jonathan Lundell
On 15 Mar 2013, at 6:45 AM, Jonathan Lundell jlund...@pobox.com wrote: I'm trying to export a largish (270K records) MySQL table via the grid or administrative export-csv functions. In both cases, I get an error after a fairly long wait; I'm assuming it's a connection timeout. Traceback

[web2py] Re: export-table timeout?

2013-03-15 Thread Niphlod
I'd need to test it again, but when I added excel-like exports my users were downloading ~50mb of files without hiccups (MSSQL though). *lost connection during query* seems to point the finger towards mysql not shipping data fast enough than web2py not fast enough to handle its

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Jonathan Lundell
On 15 Mar 2013, at 7:39 AM, Niphlod niph...@gmail.com wrote: I'd need to test it again, but when I added excel-like exports my users were downloading ~50mb of files without hiccups (MSSQL though). lost connection during query seems to point the finger towards mysql not shipping data fast

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Niphlod
you could set some filters and with the frid it should export only the records shown, not the whole table PS: passing driver_args = {} should do the job with pymysql, but I don't see any forums showing that that kind of error is driver-dependant on some kind of timeout parameter (as is in

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Jonathan Lundell
On 15 Mar 2013, at 8:15 AM, Niphlod niph...@gmail.com wrote: you could set some filters and with the frid it should export only the records shown, not the whole table I think I'll write a script to parse the database dump into a csv file instead; it's a lot quicker. But this seems like a

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Martín Mulone
In my experience recently I had many problems with pymysql, so I switch to mysqldb using dal. El 15/03/2013 13:18, Jonathan Lundell jlund...@pobox.com escribió: On 15 Mar 2013, at 8:15 AM, Niphlod niph...@gmail.com wrote: you could set some filters and with the frid it should export only the

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Jonathan Lundell
On 15 Mar 2013, at 3:44 PM, Martín Mulone mulone.mar...@gmail.com wrote: In my experience recently I had many problems with pymysql, so I switch to mysqldb using dal. I'll give it a try. A question, though. The book suggests: from gluon.dal import MySQLAdapter MySQLAdapter.driver =

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Massimo Di Pierro
On Friday, 15 March 2013 19:31:07 UTC-5, Jonathan Lundell wrote: On 15 Mar 2013, at 3:44 PM, Martín Mulone mulone...@gmail.comjavascript: wrote: In my experience recently I had many problems with pymysql, so I switch to mysqldb using dal. I'll give it a try. A question, though. The

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Massimo Di Pierro
Can you tel us something about problems. We are using it to check tests with mysql and some are failing on travis.ci we are trying to figure out why. Could it be the driver? On Friday, 15 March 2013 17:44:54 UTC-5, Martin.Mulone wrote: In my experience recently I had many problems with

Re: [web2py] Re: export-table timeout?

2013-03-15 Thread Jonathan Lundell
On 15 Mar 2013, at 7:34 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: On Friday, 15 March 2013 19:31:07 UTC-5, Jonathan Lundell wrote: On 15 Mar 2013, at 3:44 PM, Martín Mulone mulone...@gmail.com wrote: In my experience recently I had many problems with pymysql, so I switch to