Lock all the databases first, then update them. I'm pretty sure all SQL
databases have the ability to lock tables. In mySQL the sequel is:
LOCK TABLES
tbl_name [[AS] alias] lock_type
[,
tbl_name [[AS] alias] lock_type
] ...
lock_type:
READ [LOCAL]
| [LOW_PRIORITY] WRITE
UNLOCK TABLE
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
On 4/23/11 2:11 PM, "Glen Bojsza" wrote:
> Good thoughts on approaches... I am starting down the rabbit hole!
>
> thanks
Once down in the hole, you can run a second database, feed it the
transaction stream ten seconds delayed, pause the stream while you execute
queries with time-consistent resu
Good thoughts on approaches... I am starting down the rabbit hole!
thanks
On Sat, Apr 23, 2011 at 1:26 PM, Mike Bonner wrote:
> There is probably a way to do what you want directly with a single select
> but i'm a beginner to middlin of all trades, master of none. Have another
> silly idea at
There is probably a way to do what you want directly with a single select
but i'm a beginner to middlin of all trades, master of none. Have another
silly idea at the bottom, but heres more on the current questions.
I think as long as you put a semicolon between queries, and don't put a
trailing s
gt; > I don't know if this is true or not...any database or rev support people
> > out there?
> > -Original Message-
> > From: Andre Garzia
> > Sender: use-livecode-boun...@lists.runrev.com
> > Date: Sat, 23 Apr 2011 12:36:22
> > To: How to use LiveCo
unrev.com
> Date: Sat, 23 Apr 2011 12:36:22
> To: How to use LiveCode
> Reply-To: How to use LiveCode
> Subject: Re: How to sync multiple functions / routines in parallel
>
> Glen,
>
> Doing parallel queries will not work from LiveCode since RevExecuteSQL and
> friends are
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 wrote:
> Hello,
>
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 wrote:
> Hello,
>
> I have a database which I have created several q
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 c
10 matches
Mail list logo
