EasyTable: The fastest DB engine.

         As we promised earlier, now we start publishing the results of some investigations AidAim Software carried out for DB engines presented on the market. Here are the speed tests for some products of this kind. Diagram 1 presents the results of all existing speed tests for the products mentioned above. Diagram 2 presents reading speed test results, and Diagram 3 presents writing tests results. Comparison of all these products by searching speed using templates is presented at Diagram 4 (find first and find next results are compared for equality on 5 conditions. They are: Integer, Sting, Date/Time, Integer & String & DateTime, String with partial compare). Diagram 5 shows searching speed when searching for the single record matching the search criteria of the 'equiality' type (Locate by the same five conditions). Diagram 6 presents the result of comparison of the same DB engines by filtering speed (the same five conditions). Diagram 7 shows the results of comparison by BLOB fields processing speed.















         Testing had been executed on a table containing 10 000 records and including Integer/DateTime/String fields filled with data obtained by means of the standard program random-number generator, Randomize. For testing search engines after generating data, a random sequence of 1000 records is chosen, which is 10% of the whole number of records. This sequence of different records is then replaced with another sequence consisting of the same record repeatedly duplicated. This operation is performed for executing FindNext and filtering search.

         Let us now describe the tests themselves. The very first group of tests includes basic operations with tables, such as adding records, updating records, deleting records, reading table to memory (it is used for emulating direct operating with tables, without using DBGrid, DBNavigator and their analogues), as well as moving the cursor to a defined position. TTable uses the following methods for implementation of these operations: Insert, Edit, Post, Delete, First, Next, MoveBy. All the data is prepared in advance and is stored in dynamic arrays ids, ints, dates. Time measurement is the same for all the tests and is realized by means of Win API function GetTickCount, for this function measures time in milliseconds in contrast to Now function. Execution times for all such blocks are summed and then averaged out by test passes number (simple average of a single pass time is calculated). We pass through each test 10 times. The measurements results are given in Table 1.

Table 1. Tests passing time.

         We also give source codes of the testing program for each DB engine. Due to some distinctions of functions realization in different programs, we used different testing programs for any of the products being tested, using the same measurement principles. Any comer may carry out the same measurements and make sure in reliability of the results presented here. You may also be free in testing the products presented here and change the measurements principles in order to obtain, for example, the dependency of DB engine(s) operating speed on the number of records. Furthermore, you may change any of the programs presented here in order to test any other product. In any case, with any publishing of any investigations using the materials presented here (including program(s) for measurements) or the measurement principles, you must needs refer to AidAim Software as the author and the article itself.

         EasyTable detailed description is here. You may download EasyTable trial version for free.

Should you have any questions, please contact us at support@aidaim.com
© 2000-2001 AidAim Software.