Might be able to do this with a cgi. Use load with callback to send all your requests, when the load is complete, process the results, unload, and resend.
Another thought.. if the database is local (maybe even it its not local), might be able to use open process, and use a command line client to process your database queries. Finally, while probably a bad idea, if you're using revdatafromquery, I just tried "SELECT * FROM apps; SELECT * FROM users" sending 2 queries with 1 call and it returned the data from both correctly, and of course in the order they were listed. Still sequential, but sequential handled by the db engine, not rev. Depending on size of datasets and complexity of query, might be something to look at. Another potential problem with this method is the results will all be strung together so you'll have to be able to sort them out yourself. Only tried it on super simple sqlite db so mileage may vary lots On Sat, Apr 23, 2011 at 10:18 AM, <gboj...@gmail.com> wrote: > I don't know if this is true or not...any database or rev support people > out there? > -----Original Message----- > From: Andre Garzia <an...@andregarzia.com> > Sender: use-livecode-boun...@lists.runrev.com > Date: Sat, 23 Apr 2011 12:36:22 > To: How to use LiveCode<use-livecode@lists.runrev.com> > Reply-To: How to use LiveCode <use-livecode@lists.runrev.com> > Subject: Re: How to sync multiple functions / routines in parallel > > Glen, > > Doing parallel queries will not work from LiveCode since RevExecuteSQL and > friends are blocking I think. Your first query will block the engine until > it returns right? > > Andre > > On Sat, Apr 23, 2011 at 12:12 PM, Glen Bojsza <gboj...@gmail.com> wrote: > > > Hello, > > > > I have a database which I have created several queries for doing archival > > reports. > > > > Now I would like to have all the queries update the reports automatically > > every 10 seconds. > > > > From what I determined I will need to keep the database connections open > > while the application is running but I cannot do sequential queuing of > the > > queries because by the time the last query runs it will be out of sync > with > > the earliest query. > > > > So, what is the best method to have all queries update every 10 seconds > in > > parallel? Each query will have it's own database connection that is open. > > > > For anyone not doing databases this could be a similar problem in nature > > where one needs to have multiple events for gaming occur in parallel... I > > have not tried programming any games or anything else surrounding this > type > > of parallism. > > > > thanks, > > > > Glen > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > -- > http://www.andregarzia.com All We Do Is Code. > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
