Page 2 of 2
Re: Query SQL db often
Posted: Wed Apr 09, 2014 3:14 am
by KennyR
Well I guess If I was to have hundreds of thousands of records to query it could cause some latency issues with the program though...seeing that I am only going to have a few dozen messages at best at one time, querying the DB shouldn't be an issue...but I like your idea....
Re: Query SQL db often
Posted: Wed Apr 09, 2014 8:21 am
by bangkok
KennyR wrote:Ok I decided to go with the send in time option and all is working as expected. BUT there is a major crash when I attempt to query the DB using my home internet connection. I have no problems querying the DB using another internet connection, but when I connect with my home connection it crashes the IDE and closes LC. I am not sure why this is happening....I am going to attach the error log in the case that someone knows what it means...
errorLog.zip
Send again the log (or at least part of it)... Can't open the zip file.
Even an Internet connexion problem shouldn't cause Livecode to crash.
Which OS do you use at home ?
Re: Query SQL db often
Posted: Wed Apr 09, 2014 11:59 am
by Simon
Hi Bangkok,
That was my joke above...
It's not a zip file just txt with a zip suffix.
Simon
Re: Query SQL db often
Posted: Thu Apr 10, 2014 3:08 pm
by KennyR
hey guys sorry for the long delay but the forums were messed up on my end for a day....wouldn't allow me to log in....seems to be fixed now...anyhow, here is the crash log compressed the CORRECT way!
Re: Query SQL db often
Posted: Thu Apr 10, 2014 3:45 pm
by bangkok
KennyR wrote:hey guys sorry for the long delay but the forums were messed up on my end for a day....wouldn't allow me to log in....seems to be fixed now...anyhow, here is the crash log compressed the CORRECT way!
errorLog 3.zip
Wrong format. Unable to extract zip archive.
Re: Query SQL db often
Posted: Thu Apr 10, 2014 4:06 pm
by KennyR