Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

MySQL table create taking way too long

⇧
0
⇩
97 views

Hi,

I have a PHP script that creates 70 empty tables. However, it's taking nearly 30+ seconds to create them.

What is causing it to take this long? How can I speed the process up?

php mysql create
asked February 11, 2011 12:06 pm CST
Spencer
posted via StackOverflow

1 Answer

⇧
0
⇩
 

An increase in the amount of memory PHP can access might speed this up. You really aren't giving enough information to help. The code would be really useful.

answered February 11, 2011 12:23 pm CST
steve

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Why taking too long time to insert rows in a mysql table even after using multithreading when table has some relationship
January 14, 2011
MySQL insert query taking too long
February 10, 2011
Loading mysql database from dump is taking a long time
January 31, 2011
Hadoop safemode recovery - taking too long!
February 11, 2011
Server taking too long to respond error
January 17, 2011
How do you determine how long it is taking Apache to forward a request to Phusion Passenger?
January 1, 2011
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Insert into table from temporary table takes a long time
January 10, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
Autocomplete city list query taking too much time to load on huge city table
January 24, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
How to create index in two table mysql?
January 13, 2011
Mysql create a table character sets
January 25, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Mysql how to create optimum query for these table
February 11, 2011
Is there a mysql equivalent of show create table in postgres???
February 6, 2011
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
Using MySQL, I'm attempting to create a table in a db, and then insert into, but am getting a 'syntax' error
January 13, 2011
Mysql, how to create table and automatically track users who add or delete rows/tables
February 11, 2011
Mysql select query taking over 8 seconds yet limit is 5 records
December 26, 2010
PHP / MySQL - Create array of distinct values, query db table for data associated with those values, and loop for each
January 25, 2011
Create this table using my sql
February 1, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
[Solved] SQL CREATE TABLE Error
January 9, 2011
Trigger: after insert create a new table
January 7, 2011
How to create paging with multi different table?
February 1, 2011
Rails Migration Create Table Primary Key
January 22, 2011
Postgresql - CREATE TABLE SYNTAX ERROR USING LIKE -
February 2, 2011