Microsoft SQL Server may be used as the database engine for the RavTrack PC AVL system.
A free version is available from Microsoft, called “Express”. For small AVL systems where the number of tracked vehicles is small (< 25) and the update rate is fairly slow (< 30 seconds), then the EXPRESS version is probably a good choice. But, for systems requiring higher performance, Microsoft provides a number of high-performance options.
The following table describes the primary differences between the various SQL implementations.
Scalability and Performance
|Number of CPUs||1||2||4||Max OS supported||Includes support for multicore processors.|
||1 gig(GB)||3 GB||OS maximum||OS maximum||Memory limited by operating system.|
|64-bit Support||Windows on Windows (WOW)||WOW|
|Database Size||4 GB||No Limit||No Limit||No Limit|
|Partitioning||Support for large-scale databases|
|Parallel Index Operations||Parallel processing of indexing operations|
|Indexed Views||Indexed view creation is supported in all editions.|