Can you provide more information like are you using cgi to get the code and what language. What's your query look like? Are you full text indexing your text field? Do you have an index on the table? What's the table structure look like? Can you send a sample record? How many records in the table?
I query on text fields that hold html code all the time and use c++ cgi. It takes less then a second to return my query. So probably going to need more info. Thanks. Matthew Scarrow ComIT Solutions Inc. www.comit.ca Phone: 519-442-0100 Fax: 519-442-0429 -----Original Message----- From: Kyle and Beth Kelly [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 14, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: Beginner's question I am writting a search engine using Mysql. I am trying to return a text object value ( which contains all of the html), but it is taking about 10 seconds to return each text value matching my query. Is there any way that a text value can be optimized? www.cs.uno.edu/~kkelly --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
