下面是测试结果：
第一次，数据库没有创建索引，进行全表扫描：
-
- used all time is(ms):59916
-
- used all time is(ms):59150
-
- Tread 2 used all time is(ms):51223
- Tread 1 used all time is(ms):58175
- ====All thread completed!========
-
- used all time is(ms):58230
-
- Tread 2 used all time is(ms):52705
- Tread 1 used all time is(ms):58293
- ====All thread completed!========
|
第二次，数据库响应的字段创建索引，下面是测试结果：
-
- used all time is(ms):1721
-
- used all time is(ms):1737
-
- Tread 2 used all time is(ms):1684
- Tread 1 used all time is(ms):1714
- ====All thread completed!========
-
- used all time is(ms):1874
-
-
-
- used all time is(ms):1699
-
- used all time is(ms):1754
-
- Tread 1 used all time is(ms):1043
- Tread 2 used all time is(ms):1103
- ====All thread completed!========
-
- used all time is(ms):1838
-
- Tread 1 used all time is(ms):1072
- Tread 2 used all time is(ms):1139
- ====All thread completed!========
|
测试结论：
综合全表扫描访问和有索引方式的访问
单线程访问：
● 在同一个数据库实例上，双数据库没有体现出优势，甚至单数据库稍微优胜于多数据库；
● 在两个数据库实例上，双实例双实例要落后于单实例单数据库；
