MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Slow Stored Procedures
Posted by: Habib Ayob
Date: December 14, 2005 07:56AM

With AUTOCOMMIT = off and without any constraints it takes approximately 1.5 minutes for 1000 records. The test set is 1000 of the same sp calls meaning that there aren't any inserts to be carried out on the dimension tables.

This is still way too slow.

Habib

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Slow Stored Procedures
2282
Habib Ayob
December 08, 2005 06:43AM
Re: Slow Stored Procedures
1591
Per-Erik Martin
December 08, 2005 09:49AM
Re: Slow Stored Procedures
1591
Habib Ayob
December 09, 2005 07:06AM
Re: Slow Stored Procedures
1444
Per-Erik Martin
December 12, 2005 04:41AM
Re: Slow Stored Procedures
1445
Roland Bouman
December 13, 2005 08:19PM
Re: Slow Stored Procedures
1485
Habib Ayob
December 14, 2005 07:56AM
Re: Slow Stored Procedures
1499
Habib Ayob
December 14, 2005 08:15AM
Re: Slow Stored Procedures
1551
Per-Erik Martin
December 14, 2005 09:05AM
Re: Slow Stored Procedures
1665
Habib Ayob
December 19, 2005 12:57AM
Re: Slow Stored Procedures
1750
Mark Matthews
December 15, 2005 05:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.