|
Post by jamba on Jan 12, 2010 7:48:49 GMT -5
I am currently building a duplicate project--one in PowerBasic, and one in PureBasic. This will be to detail which handles certain aspects of what I need my programming tool to handle. The basic layout of this very simple program will be: - Simple GUI
- User select file (CSV)
- Code will parse file to array
- create SQLite db file
- create table in db, using first row header from file
- insert records from file, line by line (inefficient on purpose)
- once insert is complete, SELECT * from table
- and then dump all of the query contents to a file, which includes timestamps of the operation
Easy enough, right? As I was the least familiar with PureBasic, I went ahead and completed that sample project yesterday. I will probably complete the PowerBasic version today. I will be posting my results here, as well as on the PowerBasic, and PureBasic user forums...although I have high suspicion that my report to the PowerBasic forum will be deleted because of their fear of competition (which is very odd).
|
|
|
Post by jamba on Jan 13, 2010 16:41:55 GMT -5
PowerBasic Versus PureBasic DB Test Program Results ======================================================
Purpose: --------- This program steps through basic commands to test speed between the two compilers via compiled applications. Basic flow of the programs goes as follows: 1. User selects csv text file 2. Read file in to a string array 3. Parse first line as header, to get fields 4. Create SQLite DB, with table from fields from step 3 5. Loop through the string array line by line, inserting records into DB 6. Once insertion is completed, Query "SELECT * from test" and loop through records 7. Print these records to an output file, which also includes timing notes
Tests were ran with PowerBasic 5 times with small file, and again 5 times with a large file Then with PureBasic 5 times with small file, and again 5 times with a large file Small file is 50 rows, plus header row Large file is 113,776 rows, plus header row ============================================================================
Results (all times are in seconds): --------------------------------
PowerBasic: || PureBasic: ------------- || ------------- Small File: || Small File: Test 1: 0.203 || Test 1: 0.281 Test 2: 0.203 || Test 2: 0.172 Test 3: 0.171 || Test 3: 0.172 Test 4: 0.188 || Test 4: 0.172 Test 5: 0.156 || Test 5: 0.172 Avg Time: 0.1842 || Avg Time: 0.194 || Large File: || Large File: Test 1: 102.262 || Test 1: 69.109 Test 2: 100.731 || Test 2: 69.719 Test 3: 101.265 || Test 3: 68.875 Test 4: 104.406 || Test 4: 69.406 Test 5: 100.220 || Test 5: 69.047 Avg Time: 101.777 || Avg Time: 69.231 || ============================================================================
|
|
|
Post by jamba on Jan 14, 2010 22:02:25 GMT -5
I will give additional details later as I am able. For now, I have posted the sources I used HERE.
|
|
|
Post by jamba on Jan 15, 2010 9:24:03 GMT -5
|
|