- - - - - - - - - - - - - - - - - - - - - - - - - - - - Name: Adam Subject: Some performance and configuration simple questions
Hello, I have setup successfully the last DPS version and searching is working fine and fast in cache mode with stored activated. I have about 3000 documents indexed for now and proceeding by about 200 documents each time. Then after each batch of 200 documents I run -TZZZ, -THW and -TR At the beginning -TZZZ run was relatively fast but since I reached 2000 documents already in the database, it takes up to 30 MINUTES to run -TZZZ option after indexing each new 200 documents. And in addition this option makes a very huge CPU load on my server ! When looking load stats this heavy load is due to Mysql and cached processes. Is it normal with only 2500 documents ? How could I optimize something to make this faster and using less CPU time ? My server CPU is Intel Celeron 2.4Ghz with 1Go of SDRAM and OS is Fedora Core 4. Also is it necessary to run full option ZZZ each time or you can limit to only Z or ZZ ? In connection with this problem; is it normal that the table named 'cachedchk' remains empty even if after each update unix time on corresponding MySQL files is changed so the system is using these files anyway ? The last small clarification please: Until now I have used included text file to load new urls to the database. Now I'm going to use a new separate external table having the same structure as the table 'server' in main 'search' database. So I have to use the ServerTable command like follows: ServerTable mysql://user:[EMAIL PROTECTED]/dbname/tablename[?srvinfo=infotablename] What is exactly the last parameter: [?srvinfo=infotablename] ?? Should I keep as is or change something ? I have already a table named 'srvinfo' in main db. The last one: As I have already about 200 urls in my main database; if I start to use the above ServerTable command: is it true that indexer will add only new urls from my external table to its main table 'server' ? So my external table will just replace my present text file and the main 'server' table will remain the same ? Thanks in advance for your time Adam - - - - - - - - - - - - - - - - - - - - - - - - - - - - Read the full topic here: http://www.dataparksearch.org/cgi-bin/simpleforum.cgi?fid=02;post=
