Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Database size

Quote Reply
Database size
Am just curious to know... I am in the process of setting up my DbmanSql and have entered my first set of records. I have 297 subject areas with 110 records each, the description size in the db.cfg is set to 30,000 to accomadate html pages, this comes to approximately 32,600 records. Any idea how much server space this will take up?? or how large a database this will be???

Thanks in advance...

Can't never could do nothing till he whupped old couldn't till he could...
Quote Reply
Re: Database size In reply to
Database "size" for MySQL has been addressed in the support forums before...Alex just posted another post about this subject a few days ago in the Links SQL Discussion Forum...also, http://www.mysql.com has docs that outline maximum limits of data stored in MySQL database.

Of course, the "size" in terms of number of records and raw data vary depending on hardware and software...(also depends on the number of fields in your tables within databases)

Basically, average record numbers in MySQL with a limited number of fields is in the range of 75,000 to 125,000.

The most absolute number is the raw data size (exported flat file of the MySQL database) is around 2 Gigs....

Regards,

Eliot Lee
Quote Reply
Re: Database size In reply to
Just an extra point, mysql "people" reckon there is a limit of about 50,000,000 rows :)

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/