有谁在自己的软件中使用第三房数据库引擎?(300分)

W

wjs

Unregistered / Unconfirmed
GUEST, unregistred user!
请大家说一下使用的感觉,及与bde,ado的比较。
 
用过以前一个Table控件,不用任何Engine,效果还行,不过给客户做单子的时候,我还是
用BDE和ADO,其它的不敢乱用!担心技术问题。
 
我用过Diamond,有源码。比较爽。
安装起来没有BDE那么烦。
 
用过Appolo替代BDE处理xbase,非常好,发布除了程序外只需一两个dll即可.
 
我一直用DBISAM,非常不错的东西,发布时什么都不带,什么都不用设置。
 
<a href="http://www.vglib.com">http://www.vglib.com</a>
 
连acess推荐用diamond,速度快
否则用dbisam,速度快且稳定
还有什么advantage database啦
 
diamond,dbisam,MODBC,发布时方便,感觉速度也可以
 
非常感谢各位的回答!请继续。
To wjiachun:
我在 http://www.elevatesoft.com/overview.htm 看到 :
International Support:
International support for over 100 languages
可以使其提示信息(出错信息)中文化吗?
 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0039)http://www.elevatesoft.com/benchmrk.htm -->
<HTML><HEAD><TITLE>Performance Benchmarks</TITLE>
<META content="text/html;
charset=iso-8859-1" http-equiv=Content-Type>
<META content=text/css http-equiv=Content-Style-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0>
<TABLE bgColor=#ffffff border=0 borderColor=#ffffff borderColorDark=#ffffff
borderColorLight=#ffffff cellPadding=0 cellSpacing=0 width=780>
<TBODY>
<TR align=left vAlign=center>
<TD align=left bgColor=#ffffff borderColor=#ffffff borderColorDark=#ffffff
borderColorLight=#ffffff vAlign=top width="96%">
<TABLE border=0 cellPadding=6 cellSpacing=0 width="100%">
<TBODY>
<TR align=left vAlign=center>
<TD align=left vAlign=top width="100%"><FONT color=#000000
face="MS Sans Serif" size=1>
<BLOCKQUOTE>
<P align=left>&amp;nbsp;
<HR align=center color=#c0c0c0 noShade SIZE=1 width="100%"
clear="all">
<P></P>
<FONT color=#000000 face="MS Sans Serif" size=1>
<P align=left>The following are benchmarks that we have performed
with DBISAM and various competing database engines. These benchmarks
are strictly SQL-based and use only SQL SELECT queries using SQL-92
syntax, except where noted. All resultant timings are in milliseconds
and all queries were executed with a request for a live result
set, if possible.</P>
<FONT color=#000000
face="MS Sans Serif" size=1> <STRONG>Benchmark Run on 6/7/00 4:25:14
PM</STRONG></FONT><BR clear=all>
<BR
clear=all>
<TABLE bgColor=#ffffff border=0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 cellPadding=4
cellSpacing=1 width="85%">
<TBODY>
<TR align=middle bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#0008c6
borderColor=#0008c6 borderColorDark=#0008c6
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#ffffff face="MS Sans Serif" size=1>
<P align=left><STRONG>Database Engine</STRONG></P>
</FONT></TD>
<TD align=left bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#ffffff face="MS Sans Serif" size=1>
<P align=center><STRONG>Total Time (ms)</STRONG></P>
</FONT></TD>
<TD align=left bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#ffffff face="MS Sans Serif" size=1>
<P align=center><STRONG>Total Row Count</STRONG></P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Advantage V5 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>37227</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>925</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Apollo Server 5.1 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>153692</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>603</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>DBISAM V2 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1672</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1020</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Interbase (IBX) Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>2898</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>925</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>MS Access ADO Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>3990</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>925</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#ffffff
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Paradox (BDE) Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>4437</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1020</P>
</FONT></TD>
</TR>
</TBODY>
</TABLE>
<P align=left><STRONG>Notes for this Benchmark:</STRONG><BR
clear=all>
<BR clear=all>
This benchmark was run locally on a Pentium II 333 mhz workstation
with 256 megs of RAM running Windows 2000.<BR clear=all>
<BR clear=all>
The non-lookup source tables - Table1 and Table2 - were populated
with approximately 10,000 records each. The other tables - Table3,
Table4, and Table5 - contain 183, 14489, 232, and 5568 records
respectively.<BR
clear=all>
<BR clear=all>
The record count for the result set was retrieved for each query.<BR clear=all>
<BR clear=all>
The result set was not scanned for each query.<BR clear=all>
<BR clear=all>
The record range used for the parameters in each query was 100
records.</P>
<FONT color=#000000 face="MS Sans Serif" size=1> <STRONG>Query #
1</STRONG></FONT>
<P align=left><STRONG>Basic singleton SELECT on a single table using
a primary key value.</STRONG></P>
<FONT color=#000000
face="Courier New" size=2>
<P align=left>
<PRE>SELECT
*
FROM
TABLE1
WHERE
T1_KEY = :p_START</PRE>
<P></P>
</FONT>
<TABLE bgColor=#ffffff border=0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 cellPadding=4
cellSpacing=1 width="85%">
<TBODY>
<TR align=middle bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#0008c6
borderColor=#0008c6 borderColorDark=#0008c6
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#ffffff face="MS Sans Serif" size=1>
<P align=left><STRONG>Database Engine</STRONG></P>
</FONT></TD>
<TD align=left bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#ffffff face="MS Sans Serif" size=1>
<P align=center><STRONG>Time (ms)</STRONG></P>
</FONT></TD>
<TD align=left bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#ffffff face="MS Sans Serif" size=1>
<P align=center><STRONG>Row Count</STRONG></P>
</FONT></TD>
<TD align=left bgColor=#0008c6 borderColor=#0008c6
borderColorDark=#0008c6 borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#ffffff face="MS Sans Serif" size=1>
<P align=center><STRONG>Notes</STRONG></P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Advantage V5 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>234</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Apollo Server 5.1 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>602</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>DBISAM V2 Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>10</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Interbase (IBX) Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>165</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>MS Access ADO Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>217</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
<TR align=middle bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6
vAlign=center>
<TD align=left bgColor=#e0e0e0
borderColor=#0008c6 borderColorDark=#ffffff
borderColorLight=#0008c6 vAlign=top width="35%"><FONT
color=#000000 face="MS Sans Serif" size=1>
<P align=left>Paradox (BDE) Driver</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>158</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="25%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>1</P>
</FONT></TD>
<TD align=left bgColor=#e0e0e0 borderColor=#0008c6
borderColorDark=#ffffff borderColorLight=#0008c6 vAlign=top
width="15%"><FONT color=#000000 face="MS Sans Serif" size=1>
<P align=center>None</P>
</FONT></TD>
</TR>
</TBODY>
</TABLE>
<P align=left> <FONT
color=#000000 face="Courier New" size=2></font></P>
</font></blockquote>
</font></table></table>
 
又长又臭,贴出来干嘛?
 
把这一段保存为a.htm, 用IE看,会发现wjiachun is right!
 
如果你做不大的程序,推荐使用tinydb.每个表可存放100000条记录。是单数据库文件,不需要其它的东东。
www.tinydb.com.这可是国货精品。
 
多谢各位!
 
我接受答案了!
 

Similar threads

S
回复
0
查看
3K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
2K
SUNSTONE的Delphi笔记
S
D
回复
0
查看
1K
DelphiTeacher的专栏
D
顶部