← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/sql-bench/TODO

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/sql-bench/TODO
 
1
When comparing with ms-sql:
 
2
 
 
3
Check how to get MySQL faster         mysql   ms-sql
 
4
 
 
5
count_distinct (2000)               |  89.00|  39.00|
 
6
count_distinct_big (120)            | 324.00| 121.00|
 
7
count_distinct_group (1000)         | 158.00| 107.00|
 
8
count_distinct_group_on_key (1000)  |  49.00|  17.00|
 
9
count_distinct_group_on_key_parts (1| 157.00| 108.00|
 
10
order_by_big (10)                   | 197.00|  89.00|
 
11
order_by_big_key (10)               | 170.00|  82.00|
 
12
order_by_big_key2 (10)              | 163.00|  73.00|
 
13
order_by_big_key_desc (10)          | 172.00|  84.00|
 
14
order_by_big_key_diff (10)          | 193.00|  89.00|
 
15
order_by_big_key_prefix (10)        | 165.00|  72.00|                          
 
16
 
 
17
 
 
18
Why is the following slow on NT:
 
19
                                        NT     Linux
 
20
update_of_primary_key_many_keys (256| 560.00|  65.00|
 
21