Ich habe jetzt noch ein paar JOIN/ORDER BY/WHERE eingebaut:
1 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID ORDER BY a.ID:
- SQL CE: 00:00:00.0416608
- Access: 00:00:00.0822487
10 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID ORDER BY a.ID:
- SQL CE: 00:00:00.3074814
- Access: 00:00:00.7083863
100 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID ORDER BY a.ID:
- SQL CE: 00:00:03.1545674
- Access: 00:00:07.1357230
1000 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID ORDER BY a.ID:
- SQL CE: 00:00:32.6133773
- Access: 00:01:13.2414021
Sowie:
1 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID WHERE a.ID < 100 OR a.ID > 300 ORDER BY a.ID:
- SQL CE: 00:00:00.1236677
- Access: 00:00:00.1737928
10 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID WHERE a.ID < 100 OR a.ID > 300 ORDER BY a.ID:
- SQL CE: 00:00:00.3139946
- Access: 00:00:00.7289549
100 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID WHERE a.ID < 100 OR a.ID > 300 ORDER BY a.ID:
- SQL CE: 00:00:03.1246818
- Access: 00:00:07.1069451
1000 x SELECT a.* FROM Tabelle1 a LEFT JOIN Tabelle1 b ON a.ID=b.ID WHERE a.ID < 100 OR a.ID > 300 ORDER BY a.ID:
- SQL CE: 00:00:32.7180130
- Access: 00:01:13.9973234
Auch hier ist SQL CE immer noch deutlich schneller als MDB.