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½ÏÂýµÄдÈëËÙ¶ÈÓ¦¸ÃÊÇÀµÍ²åÈëËٶȵÄÔÒò¡£
Ïà¹ØÎĵµ£º
1.´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ²Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£
Õâ¸ö´íÎóÒ»°ãÖ»ÓÐÔÚʹÓÃACCESSÊý¾Ý¿âʱ²Å»á³öÏÖ¡£ÒòΪACCESSÔÚ´ò¿ªÊ±»áÉú³ÉÒ»¸öÁÙʱÎļþ.ldb£¬ÕâʱÎļþ¼ÐÈç¹ûûÓÐдÈëȨÏÞʱ£¬Ôò»á·¢Éú´íÎó¡£
½â¾ö·½·¨ÈçÏ£º
1 ......
ACCESS SQLÓï·¨²Î¿¼
=================
Ò». »ù´¡¸ÅÄî
¿ÉÒÔʹÓõÄÊý¾ÝÀàÐÍÈçÏ£º
1. TEXT£ºÎı¾ÐÍ£¨Ö¸¶¨³¤¶Èʱ£©£¬±¸×¢ÐÍ£¨²»Ö¸¶¨³¤¶Èʱ£©£»
2.
CHAR£¬NCHAR£¬VARCHAR£¬NVARCHAR£ºÎı¾ÐÍ£¬¿ÉÒÔÖ¸¶¨³¤¶È£¬·ñÔòĬÈÏֵΪ255£¡
3. ......
DELPHIÖвÙ×÷ACCESSÊý¾Ý¿â(½¨Á¢.mdbÎļþ,ѹËõÊý¾Ý¿â)
ÒÔÏ´úÂëÔÚWIN2K,D6,MDAC2.6ϲâÊÔͨ¹ý,
±àÒëºÃµÄ³ÌÐòÔÚWIN98µÚ¶þ°æÎÞACCESS»·¾³ÏÂÔËÐгɹ¦.
//ÉùÃ÷Á¬½Ó×Ö·û´®
Const
SConnectionString
= 'Provider=M ......
1¡¢VSS¿Í»§¶Ë´ò¿ª¹¤³ÌʱÌáʾ Access to file"\\***\rights.dat" denied
¸ÃÌáʾÊÇָûÓÐÍøÂç·ÃÎʵÄȨÏÞ£¬Óû§ÒªÔÚ¹²ÏíÎļþ¼ÐÓпÉдµÄȨÏ޲ſÉÒÔ¡£ÎÒÃÇÔÚÉèÖù²ÏíÎļþµÄʱºòÓ¦¸ÃÔÊÐíдÈë¡£
2¡¢ÎªVSSÉèÖû·¾³±äÁ¿
ĬÈÏÇé¿öÏÂÎÒÃÇÿ´Î´ò¿ªVSS¿Í»§¶ËÌî³äµÄÓû§Ãû¶¼Êǵ±Ç°ÏµÍ³µÇ½µÄÓû§£¬ÕâÑùʹÓÃÆðÀ´ºÜ²»·½±ã¡£Î ......
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: ......