Timeou expired
Posted by: German Muzquiz
Date: October 21, 2006 10:18AM

Hi all, I'm developing an application (in C#) that needs to read values from a Mysql table, the table contains a BLOB column (images no greater than 100KB) and information about the image.

When I run a query that search a string in one of the columns I get the error:
Timeout expired. The timeout period elapsed prior to completition of the operation or the server is not responding.

The size of the table is 6GB and it has 745262 rows, and I included in the connection string "Connect Timeout = 60", but I'm still getting this error.
If I search some ID of the table it returns the data almost inmmediately.
¿Could you help me know how to resolve this problem?

Options: ReplyQuote


Subject
Written By
Posted
Timeou expired
October 21, 2006 10:18AM
October 24, 2006 07:49AM
October 24, 2006 02:24PM
October 25, 2006 09:12AM
October 26, 2006 10:08AM
October 27, 2006 03:01PM
October 27, 2006 03:34PM
October 30, 2006 09:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.