This is an old revision of Works/Tests/DB from 2013-07-03 16:43:15..

Òåñòèðîâàíèå è èçìåðåíèå ïðîèçâîäèòåëüíîñòè äîñòóïíûõ ÁÄ

Çàìåð ïðîèçâîäèòåëüíîñòè ÁÄ âûïîëíÿëñÿ òåñòîì ÁÄ ìîäóëÿ ñèñòåìíûõ òåñòîâ, ïóò¸ì âûïîëíåíèÿ îïåðàöèé íàä çàïèñÿìè ñòðóêòóðîé: <name char(20), descr char(50), val double(10.2), id int(7), stat bool> è èçìåðåíèÿ âðåìåíè îïåðàöèè â ñåêóíäàõ.

1. DBF

Action source page doesn't exist yet(/Doc / DBF?)

2. MySQL

Action source page doesn't exist yet(/Doc / My SQL?)

3. SQLite

Action source page doesn't exist yet(/Doc / SQ Lite?)

Îïåðàöèÿ	K8-3000+, 256Ì, 120G, SQLite 3.2.2
Ñîçäàíèå 1000 çàïèñåé (ñåê):	2.2
Îáíîâëåíèå 1000 çàïèñåé (ñåê):	2.2
Ïîëó÷åíèå 1000 çàïèñåé (ñåê):	0.4
Óäàëåíèå 1000 çàïèñåé (ñåê):	1.0

OpenSCADAWiki: Works/Tests/DB ...

Òåñòèðîâàíèå è èçìåðåíèå ïðîèçâîäèòåëüíîñòè äîñòóïíûõ ÁÄ

1. DBF

2. MySQL

3. SQLite