Change search
ReferencesLink to record
Permanent link

Direct link
Optimizing the executiontime o fSQLite on an ABB robot controller
Mälardalen University, School of Innovation, Design and Engineering.
2013 (English)Independent thesis Advanced level (degree of Master (Two Years)), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

The purpose of this thesis is to generate a set of general guidelines to improve performance of the SQLite database management system for use as a component in the main computer of ABB industrial robots. This was accomplished by measuring the factors that affect query execution time and comparing SQLite features to systems it could potentially replace: chiefly ABB’s configuration storage system and real-time logging system. Results show that SQlite is slower than ABBs current configuration system and real-time logger. A series of tests were carried out that give a rough description of SQLites performance. Read and update become significantly faster when used with an index, write becomes a bit slower. In an indexed database the number of rows is not important; in a database without an index they cause significant slowing. Surprisingly, increasing the number of threads concurrently accessing a database had only a mild effect on timing.

Place, publisher, year, edition, pages
2013. , 70 p.
Keyword [en]
National Category
Computer Science
URN: urn:nbn:se:mdh:diva-22372OAI: diva2:662054
External cooperation
ABB Robotics
Subject / course
Computer Science
2013-09-13, Kappa, Högskoleplan 1, Rosenhill, Västerås, 09:45 (English)
Available from: 2013-11-11 Created: 2013-11-05 Last updated: 2013-11-11Bibliographically approved

Open Access in DiVA

fulltext(3055 kB)45 downloads
File information
File name FULLTEXT01.pdfFile size 3055 kBChecksum SHA-512
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Delight, Björn
By organisation
School of Innovation, Design and Engineering
Computer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 45 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 97 hits
ReferencesLink to record
Permanent link

Direct link