T
Thomas Bandt
Hello,
I wrote a little Test-Application which fetchs about
10 records from a SQL Server Mobile table with at all
~ 1500 records in it.
I also added a SQLite database with exactly the same data
and the same procedure.
Here is the result (duration in seconds):
SQL Server Mobile 1 42 46 38 39
SQLite 7 8 8 8
SQL Server Mobile 2 6 7 7 6
SQL Server Mobile 1 7 9 6 7
SQL Server Mobile 2 8 6 7 6
SQLite 2 2 2 2
SQL Server Mobile 1 is a encrypted .sdf with password, SQL
Server Mobile 2 is a .sdf without password and encryption.
I first thought before this test, SQL Server Mobile is so
slowly at all, but the test shows that only the first
call is so slow.
Then I thought about the decryption of the data by the
runtime at the first call. So i took the call of
SQL Server Mobile 2, which isn't encrypted, at first
position. Result: 45 seconds.
This means the decryption could not be the bottleneck.
But what else?
Greetings, Thomas
I wrote a little Test-Application which fetchs about
10 records from a SQL Server Mobile table with at all
~ 1500 records in it.
I also added a SQLite database with exactly the same data
and the same procedure.
Here is the result (duration in seconds):
SQL Server Mobile 1 42 46 38 39
SQLite 7 8 8 8
SQL Server Mobile 2 6 7 7 6
SQL Server Mobile 1 7 9 6 7
SQL Server Mobile 2 8 6 7 6
SQLite 2 2 2 2
SQL Server Mobile 1 is a encrypted .sdf with password, SQL
Server Mobile 2 is a .sdf without password and encryption.
I first thought before this test, SQL Server Mobile is so
slowly at all, but the test shows that only the first
call is so slow.
Then I thought about the decryption of the data by the
runtime at the first call. So i took the call of
SQL Server Mobile 2, which isn't encrypted, at first
position. Result: 45 seconds.
This means the decryption could not be the bottleneck.
But what else?
Greetings, Thomas