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
#2

I just tried the same query using only PDO and it works just fine.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB