I would welcome any suggestions for fine-tuning this search to run faster.
Here is the SQL. Basically what we're allowing people to do is to specify
words to search our article index.
THE TABLES:
knowledge = the knowledge base of articles
kb_categories = the category that each article is assign
0.kbid, w0.wordid. Any
suggestions for further optimization would be very welcome. We get about
3,000 searches on our database daily...
Blessings,
Justin Long
________
Justin
Long Network
for Strategic
be your
backup. | Drexel Hill,
Pennsylvania 19026
____
Justin
Long Network
for Strategic Missions
[EMAIL PROTECTED] 1732 South Park
Court
http://www.strategicnetwork.org Chesape
be your
backup. | Drexel Hill,
Pennsylvania 19026
____
Justin
Long Network
for Strategic Missions
[EMAIL PROTECTED] 1732 South Park
Court
http://www.strategicnetwork.org Chesape
;
Erik Naggum
>
--
Bruce
Momjian
|
http://candle.pha.pa.us
[EMAIL PROTECTED]
| (610) 853-3000
+ If your life is a hard drive,
| 830 Blythe Avenue
+ Christ can be your
backup. | Drexel Hill,
Pennsylv
Wow. I can't believe the difference. It didn't take too long. I'll set up
a script in my etc/cron.weekly to run it... would there be any benefit to
doing a vacuum analyze nightly?
Justin Long
At 11:10 PM 3/5/2001 -0500, you wrote:
Justin Long
<[EMAIL PROTECTED]> writes:
>
