You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi all, I am facing a problem, I am getting a query: SELECT * FROM Table1;
Executing this query via auto result = nanodbc::execute(conn, NANODBC_TEXT("SELECT * FROM Table1;"));
What I get is that all the rows from the database appear in result, and accordingly they appear in the process RAM. It is clear that I get them further through while (result.next()), but I may have a database of several gigabytes, which I don't want to put into RAM.
Is there any possibility to make a connection, make a query to the database and pull the answer one line at a time so that the whole database does not end up in RAM?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi all, I am facing a problem, I am getting a query: SELECT * FROM Table1;
Executing this query via auto result = nanodbc::execute(conn, NANODBC_TEXT("SELECT * FROM Table1;"));
What I get is that all the rows from the database appear in result, and accordingly they appear in the process RAM. It is clear that I get them further through while (result.next()), but I may have a database of several gigabytes, which I don't want to put into RAM.
Is there any possibility to make a connection, make a query to the database and pull the answer one line at a time so that the whole database does not end up in RAM?
Beta Was this translation helpful? Give feedback.
All reactions