MySQL Database SQL statements C + + ODBC interface class test results (reprint)

c++|mysql|odbc| Data | database | Statement sender: Engineer (Jean ~ still have to go, sigh ...), letter area: Linux
Title: MySQL Database SQL statements C + + ODBC interface class test results (reprint)
Letter station: BBS Water Wood Tsinghua Station (Mon Aug 9 18:03:47 1999)

The following text is reproduced from the Database discussion area.
"The original was published by engineer."
MySQL Database SQL statements C + + ODBC interface class test results

Engineer 1999.8.7

database table structure:

Database:xxx table:yyy rows:10019
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| NAME |      varchar (32) | |         PRI |       | |
| CNAME |      varchar (32) |     |         |       | |
| TYPE |      char (1) |     | |       E | |
+-------+-------------+------+-----+---------+-------+

Query method:
The position in the table is evenly distributed.

Query results:

A. (Local server,pii350/128m/8g)
A. Query string.
Total [1000 times] inquire the time is 1.105382 (s)
Average time is 0.001105 (s)
Total [3000 times] SQL time is 3.416125 (s)
Average time is 0.001139 (s)
Total [10000 times] SQL time is 11.567662 (s)
Average time is 0.001157 (s)
B. Insert record (varchar), varchar, smallint)
Total [7000 times] SQL time is 7.545522 (s)
Average time is 0.000755 (s)

B. (100M LAN server,pii350/128m/8g and pii400/128m/10g)
A. Insert record (varchar), varchar (a), smallint)
Total [10000 times] SQL time is 8.480562 (s)
Average time is 0.000848 (s)
B. Query string.
Total [10000 times] SQL time is 9.493681 (s)

Average time is 0.000949 (s)

Test conclusion:

1.MySQL as a free SQL database, the query effect is so that it can fully meet
The general system needs can be used.
2.MySQL supports a variety of BLOB data types (large strings), can store up to 600K,
16M, or even 4G size block data, consider saving large files. But you need to guarantee
Data type consistency between different SQL libraries.
3. The existing character mode and graphic mode of data management tools, more complete functions.