Community discussions

MikroTik App
 
staslabs
newbie
Topic Author
Posts: 38
Joined: Mon Feb 27, 2006 9:38 pm
Contact:

Size of DUDE database

Sun Apr 20, 2014 9:38 pm

DUDE database size exceeded 2Gb,then the program stopped working.

How to clean and compress the database of unnecessary data?
 
User avatar
rextended
Forum Guru
Forum Guru
Posts: 12001
Joined: Tue Feb 25, 2014 12:49 pm
Location: Italy
Contact:

Re: Size of DUDE database

Mon Apr 21, 2014 2:41 am

The program are installed on unit formatted with FAT32?

Extract
https://sqlite.org/2014/sqlite-shell-wi ... 080403.zip
on the same folder of the ALL FILES of dude database
and drag the dude database over sqlite3.exe and release
it's must open one shell, digit inside:
VACUUM;
do not forget ";", press enter, and wait...
 
User avatar
chechito
Forum Guru
Forum Guru
Posts: 3005
Joined: Sun Aug 24, 2014 3:14 am
Location: Bogota Colombia
Contact:

Re: Size of DUDE database

Sat Oct 25, 2014 12:08 pm

good info, i make it with my one of 320 mb and reduced to 280mb and improve certain performance
 
kjt
just joined
Posts: 1
Joined: Mon Dec 15, 2014 11:12 am

Re: Size of DUDE database

Mon Dec 15, 2014 11:18 am

What do if dude.db is over than 2GB ( ex. 2,01 GB) ?
Vacuum action gives "database image is malformed"

Who is online

Users browsing this forum: No registered users and 8 guests