Zeoslib Portal

I suspect that you mean to ask for a way to have the application gracefully timeout when a request takes longer than nn seconds. I have been searching for an answer to this for a while, and found that you could type timeout=5 in the property section of the TZconnection as I was advised to do, but it...

Even though the images that I am inserting are minute (320X240) I find that a simple select statement returning a single record (out of 10 records on the test table) takes much too long to respond. (over the internet with remote server). I tried this from the MySQL command line and found that the de...

Dear Friends, After making many attempts at getting advice on the "how" from both MySQL forums and Zeos forums, when I had almost given up hope of using the Blob field to store thumbnail images. I found a way that is a little convoluted but entirely successful. Clearly one of the major pro...

Dear Friends, In the past I was advised to link to images in their original file format and this has worked well so far. This however requires a network share to ba made available and as we are attempting to close all the security loopholes we would like to access images from within MySQL. Blob Fiel...

Dear Friends,

Should I try to TzQuery.loadfromFile on a PC with more memory, or is there some finite limit to the number of lines that can be loaded into the component.

Regards

MParak
Durban South Africa

I have tried the following:

set @@global.connect_timeout=5

but have not noticed any change.

MParak
www.cad.co.za

Dear Friends, I usually ping the remote MySQL using ICMP and if I get a response, go on to attempt to connect. This is a very effecient method of returning with the knowledge that the server is unavailable, without having the application appear ot hang while it waits for connection. If the server is...

Dear Friends, I have always referenced images in their original form and location and loaded them on the fly into a Timage component. A very fast, reliable and efficient method. This has worked well for me until I removed all network shares and suddenly need to embed the images into a blob field in ...

Hi Mark, I for one have been looking forward to using federated tables to achieve just this very task. I found however that the concept was not too evolved and that it seems to have been designed for small batches of data. The fact that the "show create" command reveals the username, passw...

Hi Hansaplast, I assume you have tried "insert into destination_table select * from source_table" and found that this is far superior to batchmove, but need to move data between databases. MySQL works on the assumption that the databases are not on the same PC and requires the user to &quo...

Dear Friends I have recently split a large table into month files and using Merge Database engine am able to view them all together in a virtual table. Even the merge table is temporary and dynamic, in that I string together just the required files to satisfy the current query. This leads to amazing...

Dear Ben, [mysql] connect_timeout=2 This sounds like a good option to help with half of the problem. Now that we can successfully timeout after failing to connect we need to timeout when a query takes too long to respond. How do we deal with a SQL script that takes longer than it should.? Regards M

We are using MySQL. (MySAM)

Dear Mark,

I was just going through this old post when I realised that the new "Federated" storage engine makes this entire process possible.

The outfile that is produced would be on the local pc's drive instead of the server's hard drive.

Regards

M Parak

Dear Friends, My application pings the server's IP address and connects when the server responds to the ping. This way I dont have to wait for connection to fail, which takes forever to respond. When the server is unresponsive, I would like the connection to fail (quickly) so my application can know...