====== Performance of SupplierArticlePools ======

A list of data from a test run of the :supplierarticlepool: using step 
[[en:prozessdefinition:jobs:jobsteps:supplier:deprecated:tradeitemmanagerdirectsql|]].

^Name^ Value^
|**booked Article details (EAN)**|44866|
|**booked Articles**|2739|
|**Size of the CSV Article catalogs**|14453 KB|
|**OS**|Microsoft Vista Business 32 bit SP1|
|**CPU**|Intel Core Quard Q9400, 2670 MHz|
|**RAM**|4 GB|
|**Database**|MS SQL 2005 Express|
|**HD1**|Western Digital WDS WD6400 AAKS 07A7B0|
|**HD2**|Western Digital WDS WD6400 AAKS 07A7B0|
|**Duration of booking**|46 min. 8 Sec|

A list of data from a test run of the :supplierarticlepool: using step "**TradeItemManager** **-FillCache/-BookCache**" using [[en:howtos:supplierarticlepool:import_update:fillcache_view|]].\\ 
The booking of over 490,000 EANs (articles with details) takes less than 3 minutes on a development PC with SQL Server 2008 and even **under 1 minute** on a 'warm' DB. Both logging in and logging in when changes are made.

^Name ^ Value^
|**Booked Article details (EAN)**|490.000|
|**OS**|Microsoft Windows 7 32 bit|
|**CPU**|Intel Core Quard Q9400, 2670 MHz|
|**RAM**|4 GB|
|**Database**|MS SQL 2008|
|**HD1**|Western Digital WDS WD6400 AAKS 07A7B0|
|**HD2**|Western Digital WDS WD6400 AAKS 07A7B0|