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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
