The Facts, Ma'am, Just the Facts

by Yi Kun Lin and Ross Mack - GUI Computing

Performed on a DX2/66, 16MB RAM, Windows 95 Retail Cut.

Database Benchmarks (Timings in minutes)
SQL for Recordset: SELECT * FROM tbl_Owners
Dataset returned to DB Grid (little difference if returned to bound textboxes). 10000 records, 5 fields (4 text fields).
SQL Server 4.21. Data Control via ODBC-attached tables on an MDB on a network drive. All tests with only one user.
Remote Data Data Control
Testing : Keyset (Type3) Updateable, Dynamic; Static (Type 1). KeysetStaticKeysetStatic
Move from first record to last19576197531328640137
Move from last record to first16315838482
Move from first record to last a second time21219630269
Internals Benchmarks (Timings in ms)
A string of length 100 chars, 10,000 iterations
String handlingVB4(32 Bit)VB4(16 Bit)VB3
Len274272
Left$(50)97210200
Right$(50)96227205
Instr124165197
Variant Handling
Len558275
Left$(50)110225212
Right$(50)110233210
Instr178247193
For…Next Loop
100,000 Iterations120150420
Form Loads (Timings in seconds)
With 140 Textboxes1.511.12.05
With 140 Imageboxes1.091.040.99


Written by: Yi Kun Lin and Ross Mack.
Aug 95



[HOME] [TABLE OF CONTENTS] [SEARCH]