Jun 07
Jon Harris [LP8.6.3] Temporary Tables
Jun 07, 2016; 09:41
Jon Harris
[LP8.6.3] Temporary Tables
Hi List
I had been struggling to produce some collated data with arrays, pairs and maps, in the end it was easier to write the data into a MySQL table, then use some joins and "order by" to get the data on the page as I need it.
This is now working ok, but the data is only temporary. I was wondering how Lasso could work with temporary (memory tables) in MySQL. Should I use temporary tables - are they a good idea?
What happens if another user loads that page, with different criteria? Should the temporary table name include a sessionid?
Alternatively, I could use a permanent table and add a session id field to the table and add that to my selection criteria. Anyone have any thoughts on using temporary data?
Any advice appreciated.
Regards
Jon
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Jun 07
Steve Piercy - Website Builder Re: [LP8.6.3] Temporary Tables
Jun 07, 2016; 03:08
Steve Piercy - Website Builder
Re: [LP8.6.3] Temporary Tables
Jun 07
Jon Harris RE: [LP8.6.3] Temporary Tables
Jun 07, 2016; 11:16
Jon Harris
RE: [LP8.6.3] Temporary Tables
Jun 07
Bil Corry Re: [LP8.6.3] Temporary Tables
Jun 07, 2016; 17:59
Bil Corry
Re: [LP8.6.3] Temporary Tables