At 10:51 AM +0300 7/16/99, Tõnu Samuel wrote:
>Paul Schwarzl wrote:
>
>> CREATE TABLE MyTable (
>> ID int(11) DEFAULT '0' NOT NULL auto_increment,
>> MYNAME varchar(80) NOT NULL,
>> MYDATUM datetime,
>> MYNUMBER int(11) NOT NULL,
>> MYTEXT int(11) ,
>> PRIMARY KEY (ID),
>> INDEX (MYNUMBER));
>
>Shorten datatypes if you can. SMALLINT MEDIUMINT TINYINT
>
>> The sql-statement are done from a php3-webpage (apache-module). The
>> mysqldamon is on the same machine.
>
>use mysql_pconnect instead of mysql_connect. This make permanent
>connections and can speed up inserts by factor of two.
mysql_pconnect() can decrease the time needed to connect to the
server, relative to mysql_connect() -- but how can mysql_pconnect()
speed up an INSERT statement?
--
Paul DuBois, paul@stripped
