It is fine now :-) I'm on different location and different network (wireless, no VPN) but anyway. fullfetch on > select * from [remoteoracle]::[TABLE] 0.234 - 0.312 sec (2,025 records, 519.5 KB) # SQL: manifold 0.284 - 0.350 sec (2,025 records, 519.5 KB) # SQL: oracle 0.429 - 0.630 sec # Oracle SQL Developer > select * from [remoteoracle]::[TABLE_2] 0.648 - 0.882 sec (10,491 records, 690.1 KB) # SQL: manifold 0.815 - 0.818 sec (10,491 records, 690.1 KB) # SQL: oracle 1.917 - 2.850 sec # Oracle SQL Developer > select a_number from [remoteoracle]::[TABLE150K] 13.123 sec (149,927 records, 1.1 MB) # SQL: manifold 5.998 sec (149,927 records, 1.1 MB) # SQL: oracle 13.109 sec # Oracle SQL Developer > select a, b, c, d from [remoteoracle]::[TABLE150K] where [AREA] < 4500 8.277 sec (7,552 records, 162.2 KB) # SQL: manifold (fullfetch effect?) 0.413 sec (7,552 records, 162.2 KB) # SQL: oracle 0.755 sec # Oracle SQL Developer > select * from TABLE150K - # SQL: manifold 602.771 sec (149,927 records, 393.8 MB) # SQL: oracle 620.676 sec # Manifold 8 (was ~120 sec last time on wired connection) - # Oracle SQL Developer > select * from TABLE150K where AREA < 4500 cancelled, too long # SQL: manifold (fullfetch effect?) 13.275 sec (7,552 records, 9.0 MB) # SQL: oracle 12.900 sec # Oracle SQL Developer
|