ID: 45856 Updated by: [EMAIL PROTECTED] Reported By: roberto at spadim dot com dot br -Status: Open +Status: Suspended Bug Type: Feature/Change Request Operating System: all PHP Version: 5.3.0alpha1 New Comment:
It's hard to do lazy loading, for example you read 10 rows then fetch the number of rows and it reads the next 2. So keeping tabs of previous rows would be required. Doing a buffered result set from the start is possible but you need to store lots more metadata so that other functions will work correctly. I don't have an intention of adding a buffered result class as it just complicates the code, You could modify your code and add COUNT(*) AS total or preload the code. Previous Comments: ------------------------------------------------------------------------ [2008-08-19 03:56:23] roberto at spadim dot com dot br Description: ------------ i'm using today sqlite2, the problem is, i don't found some functions like: sqlite_num_rows maybe SQLite3_result class should add this function, i know that have some problem because it maybe unbuffered, but when this functions is called the extension could buffer the result and use it, or when we use query function of sqlite3 class a parameter should be unbuffered / buffered i don't know, but this is a problem, i found this in PDO too, what i do? i put all result in a array (this is slower than in C) maybe a performace insue could be done with this thanks roberto spadim Reproduce code: --------------- nothing Expected result: ---------------- feature request ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=45856&edit=1
