Awesome, that will help. I am returning variable size pages. I now think the queries are slow because some of the pages are relatively large (65 KB). If I could return only a portion of the page, then that would cut down on the query time. My hard drive is definitely NOT top of the line. Thanks for the additional help. ----- Original Message ----- From: "Matthew Scarrow" <[EMAIL PROTECTED]> To: "Kyle W. Kelly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 8:26 PM Subject: RE: Beginner's question
> To return the first 500 chars of a field us the substring(str, pos, len) > function: > example > Select substring(field, 0, 500) as First500 from my_table where > something=something else; > > > > > > Matthew Scarrow > ComIT Solutions Inc. > www.bcomit.ca > Phone: 519-442-0100 > Fax: 519-442-0429 > > > -----Original Message----- > From: Kyle W. Kelly [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 7:47 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Beginner's question > > > I apologize for giving yall the wrong query. The incorrect query simply > gives the matching webpages. The query that returns the page is simple. > > select page where webpage='previously obtained page.html' > > Additionally, for the sake of completeness, the table for the word is the > following: > > table word ( > word varchar(250) not null, > webpage varchar(249) not null, > count numeric not null, > primary key (word,webpage), > index (word,webpage) > ); > Many thanks for all of the help. > Second question is it possible to only request a portion of a text value? > In other words, could I just return the first 500 bytes of a text value? > > ----- Original Message ----- > From: "Matthew Scarrow" <[EMAIL PROTECTED]> > To: "Kyle and Beth Kelly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, July 16, 2002 9:14 AM > Subject: RE: Beginner's question > > > > 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 > > > --------------------------------------------------------------------- > 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
