is this a resource problem?

From: Bufnea Darius <bufny_at_personal.ro>
Date: Thu, 30 Aug 2001 04:50:38 -0700
Message-ID: <F001.0037CBD5.20010830050621@fatcity.com>

hi guys,
first sorry my English and second sorry if this is a stupid question (or it's the wrong place to ask it)

I'm new to Oracle (few mounts) and I developed a search engine for my Univeristy. One of the table of the database contains pairs of (word, id_url). This pair is also the primary key.
So, after I insert around 300.000 words in the table the server get realy slowly
(aroud 30 seconds for something like this "select * from words where ...").
I'll expect to have more than 1.200.000 pairs (word, id_url) in my table. The machine is what my University afford, a PIII 700 Mhz machine, 256 Mb RAM, running windows nt 4 server.

Can I do someting to speed up the procces (I dont know what - reindexing, etc) or I really need a monster sun entreprise edition with 8 processor :(

Thanks,
Darius

---

Do you want a free e-mail for life ? Get it at http://www.personal.ro/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bufnea Darius
  INET: bufny_at_personal.ro

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Aug 30 2001 - 06:50:38 CDT