Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: SQLite SWEEP out of memory


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 3 - Last Post: Jan 28, 2015 1:11 AM Last Post By: Dmitry Arefiev
Larry X

Posts: 15
Registered: 6/29/06
SQLite SWEEP out of memory  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 27, 2015 2:38 PM
Invoking the SWEEP method to clean up a 3GB SQLite DB results in an out of memory error. This occurs on a windows 7 machine with 16GB of RAM. Is there anything that can be done to avoid this? I thought SQLite could handle databases much larger than that. I'm running Delphi XE6 Enterprise. Any thoughts much appreciated. Larry

Edited by: Larry X on Jan 27, 2015 6:09 PM
quinn wildman

Posts: 856
Registered: 12/2/99
Re: SQLite vacuum out of memory  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 27, 2015 2:47 PM   in response to: Larry X in response to: Larry X
My thought: Contact SQLite.

Larry X wrote:
Any thoughts much appreciated.
Larry X

Posts: 15
Registered: 6/29/06
Re: SQLite SWEEP out of memory  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 27, 2015 6:13 PM   in response to: Larry X in response to: Larry X
Thinking about this further, couldn't one just emulate the intended SWEEP (vacuum) effect by copying the database, one table at a time, into a new database, which would then be renamed to replace the original one?
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: SQLite SWEEP out of memory  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 28, 2015 1:11 AM   in response to: Larry X in response to: Larry X
http://comments.gmane.org/gmane.comp.db.sqlite.general/89233

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02