Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Fmoraes Posted February 16, 2010 Posted February 16, 2010 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.