Ticket #15004: wp-signups.php

<?php
require __DIR__ . '/src/wp-load.php';

$test_table = 'j5test_signups';

echo "- Creating $test_table table ... ";
$start = microtime( TRUE );
$wpdb->query( "
        CREATE TABLE $test_table (
                domain varchar(200) NOT NULL default '',
                path varchar(100) NOT NULL default '',
                title longtext NOT NULL,
                user_login varchar(60) NOT NULL default '',
                user_email varchar(100) NOT NULL default '',
                registered datetime NOT NULL default '0000-00-00 00:00:00',
                activated datetime NOT NULL default '0000-00-00 00:00:00',
                active tinyint(1) NOT NULL default '0',
                activation_key varchar(50) NOT NULL default '',
                meta longtext,
                KEY activation_key (activation_key),
                KEY domain (domain)
        );
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Adding 100,000 rows to $test_table ... ";
$start = microtime( TRUE );
for ( $i = 0; $i < 100000; $i++ ) {
        $wpdb->insert(
                $test_table,
                array(
                        'domain'                        => 'example.com',
                        'path'                          => '/testme/',
                        'title'                         => 'WP test',
                        'user_login'            => 'exampleusername',
                        'user_email'            => 'example@example.com',
                        'registered'            => '2013-01-01 11:11:11',
                        'activated'                     => '2013-02-02 02:02:02',
                        'active'                        => 1,
                        'activation_key'        => 'notreallyrandomjustfiller',
                        'meta'                          => 'be nice, help others, find a friend'
                ),
                array( '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%s', '%s' )
        );
}
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Adding signup_id column ( PK ) to $test_table ... ";
$start = microtime( TRUE );
$wpdb->query( "
        ALTER TABLE $test_table
        ADD signup_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Dropping key on domain column ... ";
$start = microtime( TRUE );
$wpdb->query( "
        ALTER TABLE $test_table
        DROP INDEX domain
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Adding key on domain,path ... ";
$start = microtime( TRUE );
$wpdb->query( "
        ALTER TABLE $test_table
        ADD INDEX domain_path (domain,path)
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Adding key on user_login,user_email ... ";
$start = microtime( TRUE );
$wpdb->query( "
        ALTER TABLE $test_table
        ADD INDEX user_login_email (user_login,user_email)
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Adding key on user_email ... ";
$start = microtime( TRUE );
$wpdb->query( "
        ALTER TABLE $test_table
        ADD INDEX user_email (user_email)
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";

echo "- Dropping $test_table ... ";
$start = microtime( TRUE );
$wpdb->query( "
        DROP TABLE $test_table
" );
$stop = microtime( TRUE );
$time = number_format( $stop - $start, 2 );
echo " $time seconds\n";