Query SQL db often

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

KennyR
Posts: 256
Joined: Thu Jan 19, 2012 4:25 am

Re: Query SQL db often

Post by KennyR » Wed Apr 09, 2014 3:14 am

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.... :P

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: Query SQL db often

Post by bangkok » Wed Apr 09, 2014 8:21 am

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 ?

Simon
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3901
Joined: Sat Mar 24, 2007 2:54 am

Re: Query SQL db often

Post by Simon » Wed Apr 09, 2014 11:59 am

Hi Bangkok,
That was my joke above...
It's not a zip file just txt with a zip suffix.

Simon
I used to be a newbie but then I learned how to spell teh correctly and now I'm a noob!

KennyR
Posts: 256
Joined: Thu Jan 19, 2012 4:25 am

Re: Query SQL db often

Post by KennyR » Thu Apr 10, 2014 3:08 pm

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
(19.46 KiB) Downloaded 299 times

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 937
Joined: Fri Aug 15, 2008 7:15 am

Re: Query SQL db often

Post by bangkok » Thu Apr 10, 2014 3:45 pm

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.

KennyR
Posts: 256
Joined: Thu Jan 19, 2012 4:25 am

Re: Query SQL db often

Post by KennyR » Thu Apr 10, 2014 4:06 pm

im an idiot
errorLog.zip
(19.46 KiB) Downloaded 329 times

Post Reply