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
