List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 17 1999 2:52am
Subject:Re: performance question
View as plain text  
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
Thread
Count(*) make a WRITE lock?Steven Roussey16 Jul
  • performance questionPaul Schwarzl16 Jul
    • Re: performance questionTõnu Samuel16 Jul
      • Re: performance questionPaul DuBois17 Jul
    • performance questionsinisa16 Jul
    • Re: performance questionTõnu Samuel17 Jul
      • Re: performance questionPaul DuBois17 Jul
        • Re: performance questionMichael Widenius31 Jul
  • Count(*) make a WRITE lock?sinisa16 Jul
    • RE: Count(*) make a WRITE lock?Steven Roussey18 Jul
      • RE: Count(*) make a WRITE lock?sinisa18 Jul
      • RE: Count(*) make a WRITE lock?Michael Widenius30 Jul