Announcement

Collapse
No announcement yet.

Impex huge data base

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • cokechiu
    replied
    Originally posted by Jerry
    out side of the folder you are running vBulletin in, i.e. if you have :

    /home/jerry/www/forum/
    /home/jerry/www/forum/impex

    at the moment which is the usual way, move it out like this :


    /home/jerry/www/forum/
    /home/jerry/www/impex

    So its not inside vBulletin, no time outs and slightly less memory used.
    Thank you very much, I will try it. arhh, I am working for alone.

    Leave a comment:


  • Jerry
    replied
    Originally posted by alone
    in the web root and not in the admincp <--- I don't understand

    out side of the folder you are running vBulletin in, i.e. if you have :

    /home/jerry/www/forum/
    /home/jerry/www/forum/impex

    at the moment which is the usual way, move it out like this :


    /home/jerry/www/forum/
    /home/jerry/www/impex

    So its not inside vBulletin, no time outs and slightly less memory used.

    Leave a comment:


  • alone
    replied
    in the web root and not in the admincp <--- I don't understand

    Leave a comment:


  • Jerry
    replied
    Righty, first thing to do is run impex stand alone, i.e. in the web root and not in the admincp, and set up the ImpExConfig.php.

    Secondly, if you can turn off the PHP time out and set the memory limit as high as you dare as 350,000 topics is going to take up a lot of memory when importing the posts (it loads a reference array importthreadid -> threadid). With 1G of ram I'd give PHP 512 Meg.

    Take a back up after each module.

    After importing the posts its going to take quite a while to update the parent id's also, so give it time and don't hit back or refresh.

    Leave a comment:


  • alone
    started a topic Impex huge data base

    Impex huge data base

    I would like some advice from those experts.

    Here is my situation
    ===================
    Current CMS : xoops1
    Data base size : over 2G
    Users account : 50,000
    Posts : 5,000,000
    Topics : 350,000
    PM : 1,000,000
    average user online : 600register, 600guess
    ===================

    I am going to move all data to vb3.0.7, users and forums are done.
    when importing threads and posts ( 500 each time), it timeout frequently, I chnage php execution time to 120s and timeout still occur, I am using a p4 2.4G, 1G ram pc as data base and httpd ran at another pc.

    plz give me some adivce.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X