Welcome Guest, Not a member yet? Register   Sign In
Cant fetch data on larger databases with SQL Server.
#1

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!
Reply


Messages In This Thread
Cant fetch data on larger databases with SQL Server. - by Magellan - 05-24-2021, 12:31 PM



Theme © iAndrew 2016 - Forum software by © MyBB