I have an SP which is supposed to return 8500 rows of data. I can call the SP and it will return that many rows. If I create a report in myDBR and run it, it only returns 1900 records. No errors.
More food for thought...I'm connecting to the DB via a SSH tunnel and accessing the DB as localhost. But I'm also running the SP via the GUI the same way to get the 8500 records. My timeout of my server is 20 mins.
Thanks,
jt
myDBR Team, Key Master
There are no limits myDBR imposes to the amount of rows to be fetched, so it's likely an timeout/memory issue.
What is the execution time (see myDBR statistics) of the query in myDBR and in GUI?
Have you checked the PHP/web server error logs if you see any errors?
Also, could you send us more information on your setup (you can use the support@mydbr.com)
- Database and version used
- Webserver used
- PHP version and config (max_execution_time)
- Report source code (to see what kind of output are you creating)
--
myDBR Team
You must log in to post.
