Hello,
I'm trying to use mnogosearch (v.3.1.18) with an Oracle 8 database. The
target is be able to index a huge number of url (2-300.000 or more).
However my runs stops frequently after 1000-2000 url because of lack of
space for indices, I guess mainly those related to DICT table.
So I changed a little the way tables are created to override the Oracle
default in order to have more space for indices.
Something like....
CREATE TABLE dict (
word VARCHAR2(32) NOT NULL,
url_id NUMBER(12) NOT NULL,
intag NUMBER(12) NOT NULL,
CONSTRAINT pk_dict_constraint PRIMARY KEY (word, url_id)
using index
TABLESPACE TEST
PCTFREE 5
storage (
INITIAL 4M
NEXT 2M
MINEXTENTS 1
MAXEXTENTS 9999)
)
TABLESPACE TEST
PCTUSED 95
PCTFREE 5
STORAGE
(INITIAL 4M
NEXT 2M
MINEXTENTS 1
MAXEXTENTS 9999);
With these changes I don't get anymore error on indices, but there are
ofter errors and crashes of my server (Oracle 8.1.5 on Windows NT).
I wonder if that depends on my changes or a wrong configuration of the
servers itself.
Does anybody use mnogosearch with Oracle in an intensive way?
Any suggestion in the configuration?
Thanks
Mario
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
