It looks like the entire text object is retrieved, and then a substring is returned from the text object. Are there any functions that only retrieve a portion of the text object? Meaning the whole text object is not loaded from the hard drive, and then a substring is returned. In other words, I would like a function that only loads a portion of the text object from the hard drive.
----- Original Message ----- From: "Kyle W. Kelly" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 8:30 PM Subject: Re: Beginner's question > 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 --------------------------------------------------------------------- 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