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
, 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'
. 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 f
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 return
s, 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: Beginne
-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 pri
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 t
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 optimized
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?
