Size of a Database transaction - Number of records

Question

Hi,

I have to insert approximately 96,000 rows in a table based on certain calculations. The business requirements is to have this operation in a single transaction, i.e. either all the entries are made successful or none. I am using MySQL and I could see the operation takes much more time than expected.. I shut down the operation after 4 hours and by that time only 10000 rows have been inserted. I'mlooking for a better solution.

Can anyone throw some light on better ways of handling this?

Thanks in advance,