SQLITEÓëACCESSÐÔÄܼòµ¥²âÊÔ¶Ô±È
Õâ¶Îʱ¼äÔÚ×öCMS£¨¿Í»§¹ÜÀíϵͳ£¬²»ÊÇÄÚÈݹÜÀí£©µÄ·ÃÎʹÜÀí¹¦ÄÜ£¬ÒªÇóʵÏÖ¶Ô·þÎñÌṩÉ豸£¬¿Í»§¶Ë£¬¼Æ·Ñ£¬È¨ÏÞÈÏÖ¤µÈÐÅÏ¢µÄ´æ´¢Í³¼Æ£¬Ô¶³Ì¹ÜÀí¡£ÒªÇóϵͳ·¢²¼Òª·½±ã£¬Ô¶³Ì¹ÜÀíÈí¼þÒªÅÜÔÚWINƽ̨¡£¿¼Âǵ½ÏµÍ³¹æÄ££¬¿Í»§ÒªÇó£¬×îºóÑ¡ÔñÁËWIN+ACCESSµÄ·½°¸£¬¶ø×î½üÓÖ·¢ÏÖÒ»¸öÃâ·ÑµÄSQLITE£¬¶øÇÒ¿ÉÄÜÔÚÒÔºóµÄÊÖ³ÖÉ豸ÉÏÓ㬻¨µãʱ¼ä×öÁËÈçϵļòµ¥ÐÔÄܲâÊÔ¡£
ACCESS ²åÈëÐÔÄܲâÊÔ£º
ƽ̨£ºSYS:WINXP;CPU:2*1.6GHZ;RAM:1G;APP:VC+ADO
1.µ¥ÌõÏÔʽÊÂÎñ£º
1 00Ìõ£º 0.55S
1000Ìõ£º 5s
10000Ìõ£º 50s
2.µ¥Ìõ·ÇÏÔʽÊÂÎñ£º
100Ìõ£º31ms
1000Ìõ£º156ms
10000Ìõ£º1500ms
3.ÅúÁ¿ÊÂÎñ£º
1 00Ìõ£º16ms
1000Ìõ£º141ms
10000Ìõ£º1469ms
ÒÔÉÏ¿ÉÒÔ¿´³ö£¬ACCESSµ¥Ìõ·ÇÏÔʽÊÂÎñ²åÈëµÄʱ¼ä¼¸ºõºÍÅúÁ¿ÊÂÎñµÄ²åÈëʱ¼äÒ»Ñù£¬Õâ´ó¸Å¾ÍÊÇÍøÉϵóöACCESS¿ìÓÚsqliteµÄÔÒò°É£¬µ«ÊÇ£»µ¥Ìõ·ÇÏÔʽÊÂÎñµÄ
·½Ê½Ö»ÄÜÓõ¥Á¬½Ó£¬Èç¹ûÓжà¸öÁ¬½Ó²¢·¢·ÃÎÊ£¬Ôò»á³öÏÖÑÏÖØÎÊÌ⣬ÔÚÒ»¸öÁ´½Ó²åÈëºóµÄÏ൱³¤Ò»¶Îʱ¼äÄÚ£¨ÓÐʱÊýS£©£¬ÆäËüÁ´½Ó¶¼ÎÞ·¨²åÈëÊý¾Ý¿â¡£¿ÉÒÔÍÆÀí
ADO+ACCESSÊDzÉÓÃÁËÒ»ÖÖÀàËÆCACHEµÄ×ö·¨»º´æÁ˲Ù×÷£¬µ«ÊÇÈ´Ò»Ö±Ëø×¡Êý¾Ý¿â¡£µ¥ÌõµÄÏÔʽÊÂÎñ¿ÉÒÔ±£Ö¤¶àÁ´½ÓµÄ·ÃÎÊ£¬µ«ÊÇËÙ¶È»áÂýºÜ¶à£¬ÏÂÃæÔÙ¶Ô±ÈÒ»ÏÂ
SQLITEµÄ²âÊÔÐÔÄÜ£»
SQLITE PCƽ̨²åÈëÐÔÄܲâÊÔ£º
ƽ̨£ºSYS:WINXP+VMWARE+FEDORA7(LINUX2.6.21)£»CPU;1.6GHZ;RAM:412M; APP:C+SQLITE
1.µ¥ÌõÏÔʽÊÂÎñ£¨SQLITEĬÈÏΪÿ¸ö²Ù×÷¿ªÆôÊÂÎñ£©
100Ìõ£º0.587s
1000Ìõ£º6.962s
10000Ìõ£º56.004s
2.ÅúÁ¿ÊÂÎñ
100Ìõ£º81ms£¨¿ÉÄÜÎó²î½Ï´ó£©
1000Ìõ£º124ms
10000Ìõ£º1257ms
SQLITE ǶÈëʽƽ̨²åÈëÐÔÄܲâÊÔ£º
ƽ̨£ºSYS:LINUX2.6.14;CPU:HI3512 ARM9 200MHZ¼¶±ð£»RAM:32M,ROM:32M NOR FLASH;APP:C+SQLITE
1.µ¥ÌõÏÔʽÊÂÎñ£¨SQLITEĬÈÏΪÿ¸ö²Ù×÷¿ªÆôÊÂÎñ£©
100Ìõ£º1.98s
1000Ìõ£º19.97s
10000Ìõ£º34.63s
2.ÅúÁ¿ÊÂÎñ
100Ìõ£º0.15s
1000Ìõ£º0.89s
10000Ìõ£º8.24s
ÒÔÉϿɼû£º¼´Ê¹ÔÚÐéÄâ»ú»·¾³Ï£¬SQLITE²âÊԵĽá¹ûÒÀÈ»ÓëACCESS²î²»¶à¡£¶øÔÚARM+LINUXµÄƽ̨£¬NOR FLASH½ÏÂýµÄдÈëËÙ¶ÈÓ¦¸ÃÊÇÀµÍ²åÈëËٶȵÄÔÒò¡£
Ïà¹ØÎĵµ£º
<%
function FSOFileDel(filename)
Dim objFSO,objCountFile,FiletempData
On Error Resume Next
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set objCountFile =objFSO.DeleteFile(Server.MapPath(filename),true)
objCountFile.Close
Set objCountFile=Nothing
Set objFSO = Nothing
En ......
Ò»¡¢ADO¼ò½é
ADO(Active Data Object£¬»î¶¯Êý¾Ý¶ÔÏó)ʵ¼ÊÉÏÊÇÒ»ÖÖ»ùÓÚCOM(×é¼þ¶ÔÏóÄ£ÐÍ)ÖеÄ×Ô¶¯»¯½Ó¿Ú(IDispatch)¼¼Êõ£¬²¢ÒÔOLE DB(¶ÔÏóÁ¬½ÓºÍÏâÈëµÄÊý¾Ý¿â)Ϊ»ù´¡£¬¾¹ýOLE DB¾«Ðİü×°ºóµÄÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÀûÓÃËü¿ÉÒÔ¿ìËٵĴ´½¨Êý¾Ý¿âÓ¦ÓóÌÐò¡£
ADOÌṩÁËÒ»×é·Ç³£¼òµ¥£¬½«Ò»°ãͨÓõÄÊý¾Ý·ÃÎÊϸ½Ú½øÐзâ×°µÄ¶ÔÏó¡£ÓÉÓ ......
asp.netµÄ´íÎó--Failed to access IIS metabase ÊÕ²Ø
Server Error in '/sdxx' Application.
--------------------------------------------------------------------------------
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web ......
Option Explicit
Private Sub Form_Load()
'¹¤³Ì->ÒýÓÃ->Ñ¡ÖÐMicrosoft ActiveX Data Objects 2.8 Library
Dim shujukulianjie As New ADODB.Connection
Dim jiluji As New ADODB.Recordset
'Á¬½ÓÊý¾Ý¿âµÄ´úÂë¶Î
shujukulianjie.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Sour ......
#include "iostream.h"
#include "stdio.h"
#import "C:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
int main(int argc, char* argv[])
{
::CoInitialize(NULL);
_ConnectionPtr m_pConnection;
m_pConnection.CreateInstance("ADODB.Connection");
tr ......