快速的类似sql的数据库只读操作 [英] fast sql-like database for read only operations
问题描述
我有一个web应用程序,通过.dll(vb6 dll,是VB6,请不要问为什么 - lol)连接到一个ms访问文件,它进行一些查询和向用户呈现数据。
I have a web app which through a .dll ( vb6 dll, YES VB6, please don't ask why - lol ) connects to an ms access file where it makes some queries and presents data to the user.
db文件(ms访问)很简单:它有一个约8列的表,以及〜300.000个条目和一些存储查询。因此,它是一个中等大小的数据库。
the db file ( ms access ) is simple: it has 1 table with about 8 columns, and ~300.000 entries and some stored queries. So it is a medium size database.
现在,由于大多数查询都是长的(1 - 3秒)我要找的是,如果有是一些带SQL语法的其他FASTER数据库解决方案。所有查询均为READ-ONLY。
Now, since most of the queries are kind of long ( 1 - 3 seconds ) What I'm looking for is, if there is some other FASTER database solution with SQL syntax. All queries are READ-ONLY.
需求:必须能够通过vb6连接到它
requirement: must be able to connect to it through vb6
奖金点 :如果不需要运行守护进程(如在服务器中),但它只是一个简单的文件(sqlite也许,mongo?
BONUS POINT: if there is no need to run a daemon ( as in a server ) but it's just a simple file ( sqlite maybe, mongo ? )
提前感谢!
推荐答案
http://www.sqlite.org/about.htmlrel =nofollow> SQLite : http://www.sqlite.org/about.html 和 ODBC驱动程序。具有只读模式。此外,您可能会喜欢 - 可能会从CSV档案读取资料。
Try SQLite : http://www.sqlite.org/about.html and ODBC driver. Has read-only mode. Also, what you might like - may read data from a CSV file.
或 JavaDB 和JDBC-ODBC驱动程序。
Or JavaDB and JDBC-ODBC driver.
这篇关于快速的类似sql的数据库只读操作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!