+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Cant fetch data on larger databases with SQL Server. (/showthread.php?tid=79289)
Cant fetch data on larger databases with SQL Server. - Magellan - 05-24-2021
Hi, everyone!
I'm trying to fetch some data from a table with more than 1mi rows, but i can't seem to fetch more than 12k rows at once. Is there a parameter i'm missing, or this could be a bug?
The code Below returns the first 10k rows to the $data array with no problems.
Code:
$snv = new SNVModel();
$data = $snv->findAll(10000);But if i don't specify a limit, or specify a higher one like 20000, it throws an error.
'Call to a member function getResult() on bool'
PHP Code:
$snv = new SNVModel();
$data = $snv->findAll(50000); // Call to a member function getResult() on bool
I'm running CI 4.1.2, SQL Server 19 Dev edition and PHP 7.4.
Thanks in advance!
RE: Cant fetch data on larger databases with SQL Server. - Magellan - 05-24-2021
I just tried the same query using only PDO and it works just fine.