Try adding a primary key to the table. alter table webpage add autoid INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT
This will help the database functions search through the table quicker. I think another area where the query is getting slowed down is in the translation of the Java. Java is a translated language meaning it gets compiled when it is run unlike other languages like c++ so you will see more delay when dealing with java as the interface between you and the database. Maybe running the query in the mysqlclient program and see what the response time is compared to jsp. If you see a big difference in response then it has something to do with the middle man. I can't think of anything else that will help you. 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: Monday, July 15, 2002 8:00 PM To: [EMAIL PROTECTED] Subject: Re: Beginner's question Question 1. I am using Java Server Pages on my search engine. Here is a link (http://66.190.209.122/arachnid/search.jsp) Question 2. The query is created on the fly, but the general format is: select w1.webpage, ... sum(w1.count .... and wn.count) as count from word as w1, ...word as wn where (w1.word='something' .... and wn.word='somethingelse' and w1.webpage=w2.webpage ... and wn-1.webpage=wn.webpage) group by webpage order by 2 desc Question 3. I dont know what full text indexing means. Question 4. The table structure is the following: table webpage ( webpage varchar(166) not null, host varchar(166) not null, file varchar(255) not null, level numeric not null, title varchar(166), description varchar(255), page text not null, day date not null, primary key (host, file), index(title,webpage,host), ); ----- Original Message ----- From: "Matthew Scarrow" <[EMAIL PROTECTED]> To: "Kyle and Beth Kelly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 14, 2002 7:35 PM Subject: RE: Beginner's question > 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 --------------------------------------------------------------------- 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
