Database Comparisons
| ID |
Event Description |
Access |
MSDE |
SQL |
| 1 |
Time to Login Prompt |
29 |
10 |
6 |
| 2 |
Time from Login to Main Menu |
35 |
<1 |
<1 |
| 3 |
Advanced Query, Open Items (49,900 records) |
75 |
38 |
28 |
| 4 |
Advanced Query, Closed Items (100 records) |
74 |
30 |
16 |
| 5 |
View Requests by Technician, Open (49,900 records) |
28 |
18 |
8 |
| 6 |
View Requests by Technician, Closed (100 records) |
23 |
6 |
3 |
| 7 |
View and Edit User Information Time to Open |
5 |
<1 |
<1 |
Database comparison between the various backend database options for WN Help Desk
and WN Help Desk Web. The same data was used in each test, running on a 10Mb
network. The server is a Windows 2000 Server with dual Pentium 333 processors,
256meg of RAM, and a wide-ultra SCSI hard drive. The databases tested were a
Microsoft Access 97 MDB file on the remote server using linked tables to
the MDB file, a Microsoft MSDE 1.0
SP2 database using ODBC linked tables, and a Microsoft SQL 7.0 SP2 database
using ODBC linked tables. The database contained the following
data:
- 5,000 records in the Assets table
- 50,000 records in the HelpRequests table
- 10,000 records in the UserNames table
These tests were only performed with a single connected user. Obviously,
Microsoft SQL will outperform Microsoft Access even more under a heavy
user load.
|
|
|
