I'm looking for a little advice on accessing large database files. I'm currently using an ADO control to access a 1.5GB Pervasive database file. As I understand the process, all of the data that I select from the db is cached into memory when the ADO connects to the db. This process is taking an extremely long time.
I've been out of the development side for a long time and am a little rusty. I've searched and searched for an alternate method, but to no avail. I'm hoping someone might know of a way to make this task a little more efficient.
Thanks in advance!
I've been out of the development side for a long time and am a little rusty. I've searched and searched for an alternate method, but to no avail. I'm hoping someone might know of a way to make this task a little more efficient.
Thanks in advance!