6.1. Introduction

In testing CsvSQL I used three different methods of testing procedures. The first stage was to test user input and ensure it is correctly validated. The second stage was to check if all queries and commands returned with the expected results. The final stage was to time how long it takes CsvSQL to process a file and assign it's contents to a hash of arrays.

Both the second and third test methods required several different files of different natures. These files were of different length and size. A description of these files is below.

1. Rows: 0      , Size: 0K

2. Rows: 500    , Size: 48K

3. Rows: 1000   , Size: 91K

4. Rows: 10000  , Size: 901K

5. Rows: 50000  , Size: 4.4M

6. Rows: 100000 , Size: 8.8M

7. Rows: 500000 , Size: 44M