Greetings,

Sorry about all the posts lately, but things seems to be running *really* 
slow on my database.  I have two tables, both are identical and one is used 
to hold entries older than a certain date, i.e. the history table.  I use 
this query to move the old records from one to the other.  In this case, is 
each insert part of a big transaction that commits when it is done, or is 
each insert its own transaction?  Is there anything I can do to make this 
faster?  On average the entries table has about 50,000 records and the 
history_entries table has about 3.5 million.

insert into history_entries
select * from entries where domain='somevalue' and time_stamp between 
'date1' and 'date2'

Thanks,
Matthew 


Thu, 08 Mar 2001 16:30:40 -0500
Matthew Hagerty <mhagerty@voyager.net>
Is INSERT FROM considered a transaction?