PowerBasic Vs PureBasic (a speed comparison)

[jamba]

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).

[jamba]

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
||
============================================================================

[jamba]

I will give additional details later as I am able.

For now, I have posted the sources I used HERE.

[jamba]

Forum links:
PowerBasic:
www.powerbasic.com/support/pbforums/showthread.php?p=333318#post333318

PureBasic:
www.purebasic.fr/english/viewtopic.php?f=13&t=40675