It's not the insert that are taking a long time, it's the selects.
Trying running the command with and explain in front of it to see where
you query is bottlenecking. Perhaps you don't have an index on one of
your search fields.
The first query is probably running faster because you have a few
cmt.place=y03m02_Acdt.place
AND y03m02_Acmt.charge_id=y03m02_Acdt.charge_id;
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 5:54 PM
To: [EMAIL PROTECTED]
Cc: Charles Vos
Subject: Re: Speed Up Insert Query Results
On 26 Jun 2003 at 17:45, Charles Vos w
On 26 Jun 2003 at 17:45, Charles Vos wrote:
> Could somebody please enlighten me as to why it takes nearly 2
> hours to put 8 rows of data into my table?
It's not the INSERT that's taking so long -- it's the SELECT. Try
the SELECT alone, and it will probably take the same amount of time
