16124.html
来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行
HTML
23 行
<html>
<head>
<title>阿..数据都乱了,如果有人要,再Mail给你吧(无内文)</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>阿..数据都乱了,如果有人要,再Mail给你吧(无内文)</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by 大汉堡 on July 25, 1999 at 03:04:59:<p>
In Reply to: <a href="16123.html">给点意见吧Access and VB-ADO</a> posted by 大汉堡 on July 25, 1999 at 03:01:55:<p>
: 测试用Adodc连接有Password的Access Database 发现<br>: ConnectString的Provider = Microsoft.Jet 3.51 OLEDB Provider <br>: 连不上,出现的Message我之前提出问过,但还不知Why,<br>: 但是现在我使用Provider=Microsoft OLEDB Provider for ODBC Drivers<br>: 就可顺利连上,所以顺道测试了一下两者速度的差异,如下:<br>: 统计环境:<br>: AMD K6-2 350 CPU and 192M SDRAM<br>: 100000(10万)笔资料<br>: 本机Access97 database, OP is Win98<br>: 测试方式:<br>: Private Sub Form_Activate()<br>: Time1 = Timer<br>: Set DataGrid1.DataSource = Adodc1<br>: Adodc1.Refresh<br>: Time2 = Timer<br>: MsgBox Time2 - Time1<br>: End Sub<br>: A Datagrid and a Adodc Control<br>: 数据:<br>: 时间单位:Sec<br>: ---- Provider-----Microsoft Jet.3.51 ----------------------------------OLEDB Provider for ODBC Drivers<br>: ----CmdType----Table----------Order by-----------No order--------Table----------Order by----------No order----<br>: No Inde----------2.75,2.51-----11.14,11.26--------2.79,2.62-------10.75,10.77---18.57,19.00------10.37,10.54<br>: AdUsrServer <p>: No Index--------11.26,10.65---27.01,28.17-------9.44,10.05------50.21,49.75---68.82,68.26------49.41,49.82<br>: AdUsrClient <p>: Index-------------2.14,2.08------2.08,2.08---------2.47,2.58--------10.53,10.71---15.00,15.54------10.92,10.66<br>: AdUsrServer <p>: Index-------------9.17,9.50------27.18,27.29------10.44,10.53-----50.68,49.88---68.37,68.51------48.93,48.43<br>: AdUsrClient <br>: 测试方式:<br>: Private Sub Form_Activate()<br>: Time1 = Timer<br>: Adodc1.Refresh<br>: Time2 = Timer<br>: MsgBox Time2 - Time1<br>: End Sub<br>: a Adodc Control<p>: 数据:<br>: Provider-------Microsoft Jet.3.51---------------------------------OLEDB Provider for ODBC Drivers<br>: CmdType-----Table----------Order by--------No order---------Table-----------Order by--------No order------<br>: No Index----------------------3.95,4.01----------------------------0.22,0.22------4.50,4.61-------0.22,0.15---<br>: AdUsrServer <p>: No Index-----4.83,5.38------14.99,15.05----5.44,4.78---------25.76,26.29---35.76,34.87----26.42,25.76<br>: AdUsrClient <p>: Index-----------------------------------------------------------------0.22,0.28------0.22,0.22-------0.33,0.22--<br>: AdUsrServer <p>: Index----------4.06,4.15------13.02,13.02----4.06,3.84--------25.49,25.92---35.32,34.91----25.98,25.54<br>: AdUsrClient <br>: 数据说话:<br>: 没有白吃的午餐,在功能强大的背后,要有牺牲速度的准备!!<br>: 1. 加不加索引没关系?! ODBC 显然无视Index的存在,<br>: 除了用CursorLocation = adUsrServer and Use SQL-Order by 索引的Field会加<br>: 快外,其余实在看不出啥不同<br>: 2. 牛牵到北京:CursorLocation = adUsrClient就算加了Index也丝毫不领情<br>: 3. 如果不使用Datagrid那么adUsrServer的确很惊人,量出数值已经不可靠<br>: 约<0.01<br>: 4. 两张表的Compare有个较好玩的事,就是在adUsrClient时,使用Datagrid和不<br>: 使用大约差了一倍时间,从CursorLocation的意义来看,Why??<br>: 5. 不使用Datagrid,则即使Provider用ODBC and adUsrServer也有不错的速度<br>: 这个数据希望对大家有用,有意见or 问题也请告知我<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 16124-->
</ul><!--end: 16124-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?