Skip to content

Query return speed is fine but fetch is very slow

PostgreSQL 14 PHP 7.4 I have a PHP call that returns a handle to a scrollable cursor (PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL) with about 760,000 records. The handle is being returned in a reasonable amount of time. However, once I have the handle back, doing nothing but fetching each record in a loop is ta…

Is it possible to have web index outside public html?

Say a website has this folder structure And when someone visits the website I want the physical web root to point to /public, like mywebsite.com/dikpic.jpeg (without url rewrites). This can be achieved with the root /myuser/public; command. But I also want to load the index.php file from outside this director…

How to get mongodb collection iterator?

I’m connecting to mongo db like this: Getting collection like this: And getting collection iterator like this: However last call shoots error: [error] Could not retrieve source count from demo_article: Authentication failed. What I’m doing wrong here? UPDATE: Here: iterator is Traversable. But the…