PHP中轻型的数据库抽象类：ADODB Lite
在PHP项目开发中，很多架构都是：Smarty + ADODB来做的，因为Smarty功能强大，超过了任何模板处理类，特别是缓存技术。ADODB功能强大，远远超过了PEAR::DB处理类，所以大部分人都选择ADODB做数据库抽象类，但是adodb类库非常庞大，运行速度非常慢，这样也是部分开发人员选择pear DB的原因。
但是，现在为止，这个现象要改变了，因为出来了一个ADODB的小型版： ADODB Lite
据官方网站介绍说：
支持了所有PHP能支持的流行数据库.而且据说比原来的老版本快了很多.
只需要完整版的1/6内存，完全兼容ADODB，据官方说法，可以完全不要改动代码的情况下移植到ADODB Lite下。
看官方网站的说法：
ADOdb Lite was a result of a need for a very small, fast ADOdb library for a browser based game we have been working on for over two years called Alien Assault Traders.
We noticed that the ADOdb package was consuming over 640k of ram for each HTTP access. This was even greater than the amount used by the biggest PHP program file used in the game. In effect the ADODB library was consuming vastly more resources than the game itself. This greatly restricts the number of players that can be online at the same time in respect to the amount of memory required by each client.
Currently, ADOdb Lite uses 80-85k of system ram for each HTTP access. This is about an 87% smaller memory footprint. A side benefit is an increase in speed. The speed increase will vary depending upon the database. This is also a great replacement for extremely HIGH traffic web sites.
We decided to create an ADO database library that was compatible with ADOdb and used far less memory when executed. This library has a very restricted command set and eliminates most of the esoteric commands that will not be used by most websites.
ADOdb Lite is a drop in replacement for ADOdb as long as you are not using unsupported commands on your website.
The following databases are supported:
Databasetype Designator (Database Name)
fbsq (Frontbase)
maxdb (Max DB)
msql (Mini SQL)
mssql (Microsoft SQL)
mysql (MySql)
mysqli (MySql Improved)
mysqlt (MySql w/transactions)
postgres (PostGres)
postgres64 (PostGres 6.4)
postgres7 (PostGres 7)
sqlite (SqLite)
sybase (SyBase)
The only databases that have been fully tested are the MySql databases. Drivers have been provided for the other databases and they should work. I would appreciate it if users would report how well the other database drivers function.
简直是。。。呵呵，我想是许多PHP开发者的喜欢，因为解决了速度问题。
ADODB Lite 目前最新版本是：0.0.6
官方网站：http://adodblite.sourceforge.net/
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1377
52
17 ways to solve the kernel_security_check_failure blue screen
Feb 12, 2024 pm 08:51 PM
Kernelsecuritycheckfailure (kernel check failure) is a relatively common type of stop code. However, no matter what the reason is, the blue screen error causes many users to be very distressed. Let this site carefully introduce 17 types to users. Solution. 17 solutions to kernel_security_check_failure blue screen Method 1: Remove all external devices When any external device you are using is incompatible with your version of Windows, the Kernelsecuritycheckfailure blue screen error may occur. To do this, you need to unplug all external devices before trying to restart your computer.
How to solve discuz database error
Nov 20, 2023 am 10:10 AM
The solutions to discuz database error are: 1. Check the database configuration; 2. Make sure the database server is running; 3. Check the database table status; 4. Back up the data; 5. Clear the cache; 6. Reinstall Discuz; 7. Check the server resources ; 8. Contact Discuz official support. Solving Discuz database errors requires starting from multiple aspects, gradually identifying the cause of the problem, and taking corresponding measures to repair it.
Leak reveals key specs of Intel Arrow Lake-U, -H, -HX and -S
Jun 15, 2024 pm 09:49 PM
IntelArrowLakeisexpectedtobebasedonthesameprocessorarchitectureasLunarLake,meaningthatIntel'sbrandnewLionCoveperformancecoreswillbecombinedwiththeeconomicalSkymontefficiencycores.WhileLunarLakeisonlyavailableasava
After 2 months, the humanoid robot Walker S can fold clothes
Apr 03, 2024 am 08:01 AM
Editor of Machine Power Report: Wu Xin The domestic version of the humanoid robot + large model team completed the operation task of complex flexible materials such as folding clothes for the first time. With the unveiling of Figure01, which integrates OpenAI's multi-modal large model, the related progress of domestic peers has been attracting attention. Just yesterday, UBTECH, China's "number one humanoid robot stock", released the first demo of the humanoid robot WalkerS that is deeply integrated with Baidu Wenxin's large model, showing some interesting new features. Now, WalkerS, blessed by Baidu Wenxin’s large model capabilities, looks like this. Like Figure01, WalkerS does not move around, but stands behind a desk to complete a series of tasks. It can follow human commands and fold clothes
How to uninstall Skype for Business on Win10? How to completely uninstall Skype on your computer
Feb 13, 2024 pm 12:30 PM
Can Win10 skype be uninstalled? This is a question that many users want to know, because many users find that this application is included in the default program on their computers, and they are worried that deleting it will affect the operation of the system. Let this website help users Let’s take a closer look at how to uninstall Skype for Business in Win10. How to uninstall Skype for Business in Win10 1. Click the Windows icon on the computer desktop, and then click the settings icon to enter. 2. Click "Apply". 3. Enter "Skype" in the search box and click to select the found result. 4. Click "Uninstall". 5
Can't drop database 'database_name'; database doesn't exist - How to solve MySQL error: Can't drop database, database doesn't exist
Oct 05, 2023 am 11:46 AM
How to solve MySQL error: Unable to delete database, database does not exist Overview: MySQL is a commonly used relational database management system. When using MySQL, we often need to manage the database, including creating databases, deleting databases and other operations. However, when deleting a database, sometimes you will encounter the error message "Can'tdropdatabase'database_name';databasedoesn'texist", that is, you cannot delete it.
How to use for to find the factorial of n in JavaScript
Dec 08, 2021 pm 06:04 PM
How to use for to find n factorial: 1. Use the "for (var i=1;i<=n;i++){}" statement to control the loop traversal range to "1~n"; 2. In the loop body, use "cj *=i" Multiply the numbers from 1 to n, and assign the product to the variable cj; 3. After the loop ends, the value of the variable cj is the factorial of n, and then output it.
What is the difference between foreach and for loop
Jan 05, 2023 pm 04:26 PM
Difference: 1. for loops through each data element through the index, while forEach loops through the data elements of the array through the JS underlying program; 2. for can terminate the execution of the loop through the break keyword, but forEach cannot; 3. for can control the execution of the loop by controlling the value of the loop variable, but forEach cannot; 4. for can call loop variables outside the loop, but forEach cannot call loop variables outside the loop; 5. The execution efficiency of for is higher than forEach.
