Sistertech,
Wednesday, October 23, 2002, 4:11:31 AM, you wrote:
S I'm trying to host a discussion forum for my philosophy class...to make a long
story short:
S I've now got phpBB2 and MySQL on my virtual domain.
S My host doesn't offer any MySQL support. I'm installing phpBB and
S I receive an
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matthew Scarrow wrote:
| 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.
Probably not. If the
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
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
. 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
, 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
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?
Hi Kelly,
| 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