Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Thu Mar 10 15:38:46 CST 2011
Hi John -- Here are my test results for sample code I've just posted (hopefully it get through AccessD - it was a bit lengthy) //11/03/2011 0:32:50: Test Started. //Total Threads Count = 20 //Store has 0 objects, Created = 70, Removed = 70 //RemovalRetriesCount = 0, FailedRemovalsCount = 0 //11/03/2011 0:32:50: Test Finished. //11/03/2011 0:32:25: Test Started. //Total Threads Count = 200 //Store has 0 objects, Created = 700, Removed = 700 //RemovalRetriesCount = 0, FailedRemovalsCount = 0 //11/03/2011 0:32:25: Test Finished. //11/03/2011 0:31:32: Test Started. //Total Threads Count = 20000 //Store has 19 objects, Created = 70000, Removed = 69981 //RemovalRetriesCount = 295, FailedRemovalsCount = 19 //11/03/2011 0:31:43: Test Finished. //11/03/2011 0:33:32: Test Started. //[3]: Object Added - ID = 1, TS = 634354004122968750 //[5]: Object Added - ID = 2, TS = 634354004122968750 //[3]: Object Added - ID = 3, TS = 634354004122968750 //[4]: Object Removed - ID = 2, TS = 634354004122968750 //[5]: Object Added - ID = 4, TS = 634354004122968750 //[6]: Object Removed - ID = 3, TS = 634354004122968750 //[7]: Object Added - ID = 5, TS = 634354004122968750 //[8]: Object Removed - ID = 4, TS = 634354004122968750 //[9]: Object Added - ID = 6, TS = 634354004122968750 //[10]: Object Removed - ID = 1, TS = 634354004122968750 //[11]: Object Added - ID = 7, TS = 634354004122968750 //[3]: Object Added - ID = 8, TS = 634354004122968750 //[12]: Object Removed - ID = 7, TS = 634354004122968750 //[5]: Object Added - ID = 9, TS = 634354004122968750 //[7]: Object Added - ID = 11, TS = 634354004122968750 //[9]: Object Added - ID = 10, TS = 634354004122968750 //[4]: Object Removed - ID = 6, TS = 634354004122968750 //[11]: Object Added - ID = 12, TS = 634354004122968750 //[3]: Object Added - ID = 13, TS = 634354004122968750 //[7]: Object Added - ID = 16, TS = 634354004123125000 //[6]: Object Removed - ID = 13, TS = 634354004122968750 //[11]: Object Added - ID = 17, TS = 634354004123125000 //[9]: Object Added - ID = 15, TS = 634354004123125000 //[4]: Object Removed - ID = 16, TS = 634354004123125000 //[8]: Object Removed - ID = 11, TS = 634354004122968750 //[10]: Object Removed - ID = 8, TS = 634354004122968750 //[5]: Object Added - ID = 14, TS = 634354004122968750 //[11]: Object Added - ID = 21, TS = 634354004123125000 //[3]: Object Added - ID = 18, TS = 634354004123125000 //[7]: Object Added - ID = 19, TS = 634354004123125000 //[10]: Object Removed - ID = 15, TS = 634354004123125000 //[6]: Object Removed - ID = 5, TS = 634354004122968750 //[4]: Object Removed - ID = 19, TS = 634354004123125000 //[8]: Object Removed - ID = 9, TS = 634354004122968750 //[10]: Object Removed - ID = 21, TS = 634354004123125000 //[6]: Object Removed - ID = 17, TS = 634354004123125000 //[8]: Object Removed - ID = 12, TS = 634354004122968750 //[4]: Object Removed - ID = 22, TS = 634354004123281250 //[12]: Object Removed - ID = 10, TS = 634354004122968750 //[6]: Object Removed - ID = 18, TS = 634354004123125000 //[4]: Object Removed - ID = 24, TS = 634354004123437500 //[8]: Object Removed - ID = 20, TS = 634354004123125000 //[6]: Object Removed - ID = 23, TS = 634354004123437500 //[12]: Object Removed - ID = 25, TS = 634354004123437500 //[10]: Object Removed - ID = 14, TS = 634354004122968750 //[9]: Object Added - ID = 20, TS = 634354004123125000 //[5]: Object Added - ID = 22, TS = 634354004123281250 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[10]: Object Removed - ID = 26, TS = 634354004124062500 //[6]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: Object Removal failed, retry attempt# 1 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[10]: Object Removed - ID = 27, TS = 634354004124062500 //[3]: Object Added - ID = 24, TS = 634354004123437500 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[6]: Object Removal failed, retry attempt# 1 //[6]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: Object Removal failed, retry attempt# 2 //[4]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[8]: Object Removal failed, retry attempt# 1 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[11]: Object Added - ID = 23, TS = 634354004123437500 //[7]: Object Added - ID = 25, TS = 634354004123437500 //[6]: Object Removal failed, retry attempt# 2 //[12]: Object Removed - ID = 28, TS = 634354004124531250 //[4]: Object Removal failed, retry attempt# 1 //[8]: Object Removal failed, retry attempt# 2 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[6]: Object Removed - ID = 29, TS = 634354004125000000 //[4]: Object Removed - ID = 30, TS = 634354004125000000 //[8]: Object Removal failed, retry attempt# 3 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: Object Removal failed, retry attempt# 1 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[8]: Object Removal failed, retry attempt# 4 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: Object Removal failed, retry attempt# 2 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[3]: Object Added - ID = 28, TS = 634354004124531250 //[12]: Object Removal failed, retry attempt# 3 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[8]: Object Removal failed, retry attempt# 5 //[8]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[12]: Object Removal failed, retry attempt# 4 //[7]: Object Added - ID = 30, TS = 634354004125000000 //[12]: RemoveRandomObject: 'maxValue' must be greater than zero. //Parameter name: maxValue, index = -1, key = -1 //[5]: Object Added - ID = 27, TS = 634354004124062500 //[9]: Object Added - ID = 26, TS = 634354004124062500 //[12]: Object Removal failed, retry attempt# 5 //[12]: Object Removed - ID = 31, TS = 634354004126093750 //[8]: Object Removal failed //[8]: Object Removed - ID = 32, TS = 634354004126250000 //[9]: Object Added - ID = 33, TS = 634354004126250000 //[12]: Object Removed - ID = 33, TS = 634354004126250000 //[11]: Object Added - ID = 29, TS = 634354004125000000 //[9]: Object Added - ID = 34, TS = 634354004126406250 //[12]: Object Removed - ID = 34, TS = 634354004126406250 //[7]: Object Added - ID = 31, TS = 634354004126093750 //[5]: Object Added - ID = 32, TS = 634354004126250000 //[11]: Object Added - ID = 35, TS = 634354004126406250 //Total Threads Count = 10 //Store has 1 objects, Created = 35, Removed = 34 //RemovalRetriesCount = 15, FailedRemovalsCount = 1 //11/03/2011 0:33:32: Test Finished. Thank you. -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 10 ????? 2011 ?. 16:13 To: VBA Subject: [dba-VB] c# lock() <<< snip >>>