LMPX.COM |
Home | Linux | Mysql | PHP | XML | ||
|
|
|||
From: scottmac@php.net Date: Tue Aug 19 08:56:44 2008 Subject: #45856 [Opn->Sus]: sqlite3 extension, some functions not found
ID: 45856
Updated by: scottmac@php.net
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
| Navigate in group php.bugs at sever news.php.net | |
| Previous | Next |
| © No Copyright You are free to use Anything |
Site Maintained by PHP Developer
Powered By PHP Consultants |