How to sync multiple functions / routines in parallel

[Andre Garzia]

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 <gbojsza at 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 at 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.