Skip to content

texhex/SQLitePragmaPerf

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQLitePragmaPerf

IN EARLY DEVELOPMENT. PLEASE IGNORE FOR NOW

Wer mißt, mißt Mist -German proverb

This project tests the effect of System.Data.SQLite database connection settings or PRAGMA statement on different SQL statements. When all tests are run, it generates CSV files which can be further analyzed.

It’s intent to proof or disproof if pragma X set to Y would result in a 420% performance gain.

##Limitations

This project depends on the StopWatch class, it cannot provide 100% accurate timings and is not a benchmark tool.

It does also not support all SQLite PRAGMA statements, for example checkpoint_fullfsync or fullfsync as those are only supported on Mac OS.

##Download

The most recent version can be downloaded from Releases.

##Documentation

Please see the Wiki for documentation.

##Additional resources

##Contributions

Any constructive contribution is very welcome!

If you encounter a bug, please create a new issue, describing how to reproduce the bug and we will try to fix it. Pull requests for source code changes or scripts are welcome as well.

##Copyright and License

Copyright © 2016 Michael ‘Tex’ Hex (@texhex).

Licensed under the Apache License, Version 2.0. For details, please see LICENSE.txt.

About

NOT USABLE RIGHT NOW Configurable System.Data.SQLite pragma performance testing

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published