How to sync multiple functions / routines in parallel

[Nonsanity]

So you have data in memory that is constantly being updated, and need to
save the data to several databases periodically. But when you save to each
database in sequence, the data could be updated in between them, causing the
databases to be out-of-sync.

So what you could do is snapshot the data in memory by making a copy of it,
then use the static copy to write to each database in turn. This keeps them
safe from the continuous updates.


 ~ Chris Innanen
 ~ Nonsanity


On Sat, Apr 23, 2011 at 11:12 AM, 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
>