Forum Post: RE: Fetching over 400 000 records from database via odbc php.

  • Thread starter Thread starter Libor Laubacher
  • Start date Start date
Status
Not open for further replies.
L

Libor Laubacher

Guest
The first question would be why does someone need to fetch 22 1/2 mil records at the first place .... eg for what reason? Secondly SELECT COUNT(*) is supposed to return 1 record, so no need to change any "fetch" parameters. If the JDBC works fine and ODBC does not, there might be a problem in the ODBC driver, so upgrading to more recent version might be a solution (10.1B is kinda old), or trying to unixODBC CLI first to see if the problem's there as well. Or JDBC/ODBC bridge.

Continue reading...
 
Status
Not open for further replies.
Back
Top