Jump to content

Convert For Vb4 realy slow


Recommended Posts

Posted

I'm having a little problem with the conversion of VB4 to the IPB, the members table is very slow ..
In 24 hours the conversion convertino were only 200,000 users, and in the database have 800,000 registered users. ...

Are there any way to optimize the conversion of this table?

According to the PhpMyadmin a query that takes longer to be used is this:

SELECT email, members_l_username, members_l_display_name FROM ipb_members WHERE email =''OR members_

based on the string above, I believe the slowness is due to give this line of code

$this->DB->build( array( 'select' => 'email, members_l_username, members_l_display_name', 'from' => 'members', 'where' => "email='".$this->DB->addslashes($email)."' OR members_l_username='".$this->DB->addslashes($lowername)."' OR members_l_display_name='".$this->DB->addslashes($lowerdname)."'" ) );



Thanks for help

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...