FiveTech Support Forums

Dear All,

I just try to work with MySql (on web hosting). I would like to know the real working concept. Because when I use from my small knowledge the problem is the connection and reading not stable. It shows the data less than 1 seconds for 2 or 3 times and then the next time will take 5-10 seconds and next may be over 10 seconds. The problem might be my knowledge in RDBMS on web. I am not sure the real concept to access, read and write procedure.
My flow is below;


Thanks in advance for any help and idea.

Dutch,

dutch wrote:It shows the data less than 1 seconds for 2 or 3 times and then the next time will take 5-10 seconds and next may be over 10 seconds.

It could be a problem of the server where MySQL is installed.

EMG

Dear EMG,

Thank you again EMG. I'm not quit sure my idea that my understood correct or not?
oServer:Query() = DbUseArea()
oDb:End() = DbCloseArea()
Can I use it often as DBFCDX? Because I will open() when I use and close() when finish.

Regards,
Dutch

Dutch,

dutch wrote:Dear EMG,

Thank you again EMG. I'm not quit sure my idea that my understood correct or not?
oServer:Query() = DbUseArea()
oDb:End() = DbCloseArea()
Can I use it often as DBFCDX? Because I will open() when I use and close() when finish.

Regards,
Dutch

Sorry, I don't know what MySqlServer() does. Anyway, you can open and close queries as many as you want but keep in mind that any queries will require to download all the records in the recordset from the database server.

EMG

Dutch,

Maybe this helps. http://www.chriscalender.com/?p=1278