FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Rebuild search index part by part
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Rebuild search index part by part [message #30514 is a reply to message #30461] Tue, 28 February 2006 20:46 Go to previous messageGo to previous message
wariat is currently offline  wariat   Poland
Messages: 22
Registered: April 2005
Location: Poznań/Poland
Karma:
Junior Member

Do you mean to set

@set_time_limit(2400);

in adm/indexdb.php

To low value, e.g. 100 seconds and than start to rebuild index via admin panel?

Or maby:

you mean to change the line:

74: q('INSERT INTO '.$tbl.'search_cache (srch_query, query_type, expiry, msg_id, n_match) VALUES(\'\', -'.$r[0].', 0,0,0)');
75: index_text($subj, read_msg_body($r[3], $r[2], $r[4]), $r[0]);


to:


74: q('INSERT INTO '.$tbl.'search_cache (srch_query, query_type, expiry, msg_id, n_match) VALUES(\'\', -'.$r[0].', 0,0,0) LIMIT 100');


I'm not sure where it (LIMIT 100) should be placed ?

maby:

66: $c = q('SELECT id, subject, length, foff, file_id FROM '.$tbl.'msg WHERE '.($sid ? ' id>'.$sid.' AND ' : '').' apr=1 ORDER BY subject');


like:

66: $c = q('SELECT id, subject, length, foff, file_id FROM '.$tbl.'msg WHERE '.($sid ? ' id>'.$sid.' AND ' : '').' apr=1 ORDER BY subject' LIMIT 100);


please tell me if you are talking just about change like this in the file and than just rebuild index. I don't understand this script, and I'm affraid to make something wrong. I takes me 3 days (and 2 nights) to make a forum usable, don't want to kill it by wrong modification of indexdb.php, but also i want to get back search funcionality.


[Updated on: Wed, 01 March 2006 16:38]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: TREE VIEW not staying as default....it is always switching back to flat.
Next Topic: different themes for different forums.
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 17 16:49:25 GMT 2025

Total time taken to generate the page: 0.03802 seconds