[web2py] Re: Asynchronous Background Processes

2014-11-11 Thread Josh L
Tim - Thanks - at first I was wary of the AJAX approach because I would have to submit multiple ajax requests, then multiple additional requests to get the image data. But I found that I could return base64 encoded image data with the ajax request and display that instead, saving another HTTP c

[web2py] Re: Asynchronous Background Processes

2014-11-06 Thread Josh L
> cpu-bound. > > On Monday, November 3, 2014 7:03:23 PM UTC+1, Josh L wrote: >> >> Unfortunately after lots of experimentation I wasn't able to get the >> multiprocessing module to work with web2py. What I did find however was >> that I could use subprocess.che

[web2py] Re: Asynchronous Background Processes

2014-11-04 Thread Josh L
Unfortunately after lots of experimentation I wasn't able to get the multiprocessing module to work with web2py. What I did find however was that I could use subprocess.check_output to launch a Python script containing the multiprocessing module and a pool of workers, and I can get data to the

[web2py] Asynchronous Background Processes

2014-10-31 Thread Josh L
I'm trying to solve a business problem where I need to cache many images, around 20 at a time from a third party website on my server and then serve those to a client. A key requirement is that they be made available as quickly as possible, so for this reason I started building a function in We

[web2py] Re: DAL calls fail after first stored procedure call

2014-08-25 Thread Josh L
For now I'm just using a mysqldb.connect(options) object directly with a cursor to call my SP, bypassing the web2py DAL completely. Of course this means I have to create a new DB connection for every SP call, and I'm thinking performance wise this might be worse off than just not using an SP al

[web2py] Re: DAL calls fail after first stored procedure call

2014-08-21 Thread Josh L
This still seems to be an issue for me running 2.9.5-stable+timestamp.2014.03.16.02.35.39. I tried both mysqldb and the default pymysql driver. I want to use a stored procedure to run a lengthy query that is run quite often by my application. This behavior should be easily reproducable using a