ilto:[EMAIL PROTECTED]]
> Sent: Monday, October 22, 2001 4:01 AM
> To: [EMAIL PROTECTED]
> Subject: faster inserts & updates
>
>
> Hi
>
> I have a PHP program which adds records to a MySQL table. The number of
> records in the table after the execution of the progra
On Monday 22 October 2001 18:25 pm, Priya Ramkumar wrote:
> Hi Tom,
>
> Thanks for your response. It takes around 1 hour & 40 minutes to
> insert 28000+ records. Also, I find that the first few thousand
> transactions are quite fast but slows down later. I have MySQL on
> Linux. I have a concaten
]
Subject: faster inserts & updates
Hi
I have a PHP program which adds records to a MySQL table. The number of
records in the table after the execution of the program is around 28,000. I
also have select & update queries in the program on the same table. The
process takes a very long
educe the amount of indexing in order to speed up
your inserts...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Priya Ramkumar [mailto:[EMAIL PROTECTED]]
Sent: 22 October 2001 06:26
To: Haapanen, Tom
Cc: [EMAIL PROTECTED]
Subject: Re: faster inserts & updates
Hi Tom,
T
tain? What
kind
> of primary keys and indices do you have?
>
>
> Tom Haapanen
> [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Priya Ramkumar [mailto:[EMAIL PROTECTED]]
> Sent: 22 October 2001 06:01
> To: [EMAIL PROTECTED]
> Subject: faster inserts &
PROTECTED]]
Sent: 22 October 2001 06:01
To: [EMAIL PROTECTED]
Subject: faster inserts & updates
I have a PHP program which adds records to a MySQL table. The number of
records in the table after the execution of the program is around 28,000. I
also have select & update queries in the pr
Hi
I have a PHP program which adds records to a MySQL table. The number of
records in the table after the execution of the program is around 28,000. I
also have select & update queries in the program on the same table. The
process takes a very long time to complete all insertions to the table. I