MySQL 5.0 Alpha
Jdbc Driver: Connector J
OS: Windows 2000 Professional
Table Size 1 Mil. Records.
Table Structure:
Table1
logid - autoincrement int(11)
Timestamp - timestamp
Timestamp2 - timestamp
Tag - varchar(15)
Query/Code:
---
PreparedStatement pst = con.prepareStatement(Select
The problem is not the memory on the database server, but on the client
running the JDBC connection. Seems that when you retrieve the result it
is trying to store everything in memory at once.
Here is some info from the mysql docs that looks like it pertains, see
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John McCaskey wrote:
| The problem is not the memory on the database server, but on the client
| running the JDBC connection. Seems that when you retrieve the result it
| is trying to store everything in memory at once.
|
| Here is some info from the