Bonjour, Pas automatiquement complètement représentatif (les configurations ne sotn pas tous identiques), mais cela donne une bonne idée. n = 4999, test lancé depuis eclipse sur mon ordinateur. A noter qu'oracle est sur le nouveau serveur. mysql et postgress tourne sur prof derby, mkoi tourne en local (donc machine moins puissante que les serveurs, mais pas de réseau). A noter que sur oracle j'ai un problème de récupération de données. Le tableau de bytes étant mal formé. Je n'arrive pas à résoudre le problème. ----------------- Apache Derby (Cloudscape) Embedded time to create(4999): 401 9%(6193/6193) 19%(4262/10455) 29%(4629/15084) 39%(4240/19324) 49%(3916/23240) 59%(4257/27497) 69%(3522/31019) 79%(3499/34518) 89%(4326/38844) 99%(3519/42363) time to store: 42446 time to commit: 38042 -- Total time: 80889 time_storeList: 0 time_storeOne: 42349 time_store: 32035 time_managementExists: 2283 time_saveManagement: 3982 time_saveData: 25666 time_objectToDatabase: 1092 time_databaseToObject: 0 INFO: ids.size: 0 ----------------- Mysql ---------------------- time to create(4999): 102 9%(2901/2901) 19%(2563/5464) 29%(2374/7838) 39%(3130/10968) 49%(2550/13518) 59%(2642/16160) 69%(2588/18748) 79%(2658/21406) 89%(2592/23998) 99%(2257/26255) time to store: 26299 time to commit: 4563 -- Total time: 30964 time_storeList: 0 time_storeOne: 26261 time_store: 21509 time_managementExists: 3146 time_saveManagement: 2625 time_saveData: 15680 time_objectToDatabase: 529 time_databaseToObject: 0 9 août 2005 15:41:02 INFO: ids.size: 5005 ----------------- Apache Derby (Cloudscape) Network time to create(4999): 128 9%(9113/9113) 19%(5933/15046) 29%(6373/21419) 39%(6123/27542) 49%(5591/33133) 59%(5987/39120) 69%(5070/44190) 79%(5418/49608) 89%(5975/55583) 99%(5368/60951) time to store: 61040 time to commit: 39259 -- Total time: 100427 time_storeList: 0 time_storeOne: 61007 time_store: 48506 time_managementExists: 7342 time_saveManagement: 5350 time_saveData: 35744 time_objectToDatabase: 615 time_databaseToObject: 0 INFO: ids.size: 0 ----------------- Mckoi Embedded ---------------------- time to create(4999): 94 9%(29002/29002) 19%(29706/58708) 29%(32774/91482) 39%(38446/129928) 49%(42870/172798) 59%(46945/219743) 69%(52695/272438) 79%(55663/328101) 89%(59455/387556) 99%(63894/451450) time to store: 452893 time to commit: 395023 -- Total time: 848010 time_storeList: 0 time_storeOne: 452851 time_store: 205851 time_managementExists: 6252 time_saveManagement: 9030 time_saveData: 190484 time_objectToDatabase: 1046 time_databaseToObject: 0 9 août 2005 15:57:15 INFO: ids.size: 5002 ----------------- Postgresql ---------------------- time to create(4999): 92 9%(17731/17731) 19%(17912/35643) 29%(19204/54847) 39%(20373/75220) 49%(22224/97444) 59%(24592/122036) 69%(25355/147391) 79%(25817/173208) 89%(25545/198753) 99%(24245/222998) time to store: 223439 time to commit: 27584 -- Total time: 251115 time_storeList: 0 time_storeOne: 223409 time_store: 84107 time_managementExists: 49942 time_saveManagement: 3893 time_saveData: 30201 time_objectToDatabase: 562 time_databaseToObject: 0 INFO: ids.size: 5002 ----------------- Oracle ---------------------- time to create(4999): 363 9%(7845/7845) 19%(9676/17521) 29%(8710/26231) 39%(8846/35077) 49%(8355/43432) 59%(9073/52505) 69%(9614/62119) 79%(8932/71051) 89%(9503/80554) 99%(8871/89425) time to store: 89547 time to commit: 25711 -- Total time: 115621 time_storeList: 0 time_storeOne: 89520 time_store: 39306 time_managementExists: 5461 time_saveManagement: 4788 time_saveData: 28968 time_objectToDatabase: 669 time_databaseToObject: 0 INFO: ids.size: 0 ----------------- Mckoi in Memory ---------------------- time to create(4999): 118 9%(37695/37695) 19%(38595/76290) 29%(41793/118083) 39%(46296/164379) 49%(50124/214503) 59%(54547/269050) 69%(59661/328711) 79%(67487/396198) 89%(78354/474552) 99%(82347/556899) time to store: 558499 time to commit: 539540 -- Total time: 1098157 time_storeList: 0 time_storeOne: 558460 time_store: 257374 time_managementExists: 6737 time_saveManagement: 9854 time_saveData: 240719 time_objectToDatabase: 1078 time_databaseToObject: 0 ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- ----------------- Mckoi in Memory ---------------------- 9 août 2005 16:23:41 org.codelutin.topia.persistence.AbstractPersistenceStorageTestCase testGetAllId INFO: ids.size: 5002