mysql database?

vizplay · 10-12-2007, 03:35 PM

Hi,
How much storage space do Game scripts in the mysql database? I'm currently thinking of getting a hosting package with 100mb of database storage, will that be enough?
thanks for any advice.
vizplay

microjoes · 10-12-2007, 04:39 PM

100mb is ok. A data base can get very big after users register and make comments and use the other features. Over time the database will grow but 100 mb is more than enough to start.

RickyG · 10-12-2007, 06:05 PM

Datebase storage or space?

Sql is a lot smaller than the SWF's for an arcade site.

RickyG

brendgard · 10-13-2007, 01:07 AM

I've seen MySQL databases with 30,000 entries that take up just over 2 megs. for an arcade, 100 megs database space is more than enough to start out with.

If you're talking main disk space though, that's another story. 100 megs won't even begin to cover it for an arcade's main diskspace.

RickyG · 10-13-2007, 05:14 AM

2 megs DB is still small. I have seen larger DB for things like blogs or forums, cause all lthe posts become the db. As far as an arcade DB goes.... small. Even whith users signing up, it is only 1 line of (text) DB.

microjoes · 10-13-2007, 08:35 AM

Quote:

Originally Posted by RickyG

2 megs DB is still small. I have seen larger DB for things like blogs or forums, cause all lthe posts become the db. As far as an arcade DB goes.... small. Even whith users signing up, it is only 1 line of (text) DB.

I have joomla databases that are 20mb and bigger.

RickyG · 10-13-2007, 08:40 AM

Quote:

Originally Posted by microjoes

I have joomla databases that are 20mb and bigger.

Correct
The post becomes the db... Each charactor adds to the db. For aracade it is low txt, unless you have a forum attached.

RickyG · 10-13-2007, 10:03 AM

Now that I am home on the lappie, let me try to explain further....kinda tough on the Black Berry....LOL!

A SQL file for a forum holds all the posts. Depending on how many posts, lenghth, and memebrs wil make the SQL large(R). If you own a phpbb of joomla or a off the shelf php app, you dont need to DL the whole site for a BU. You only need 2 things.
1- sql <> this wil have all posts and such
2- any "special" template files and logo.

With that you can go to any server and rebuild your site. A few clicks with fantasico and the SQL ...ALL DONE.

Now that I said all of that...an arcade in comparsion takes little SQL database. It needs some simple command lines to tie in the SWF/Thumb/link. It also contains the data for users. Now, remeber.....a SQL for an arcade site can be large, if there is any type of blog, forum, or anything tied to it.

Just like a song site I have. It has over 100,000 full length song lyrics. That DB is 251 meg in size. If it was just song titles, it migth be a few K in size.

The qusetion asked above was on an arcade site..
RickyG

john274 · 10-18-2007, 12:16 PM

It depends really on the database setup and how many indexes it has as well.

If you are just talking about the database then an active site would eventually need more than 100mb's, but that would take a while to get that amount.

If you are talking about the games hosted on your server as well then you will probably be able to have around 150 games that are on average 500kb's each.

10-12-2007, 03:35 PM	#1 (permalink)
vizplay Contributing Member Join Date: Oct 2007 Posts: 29	mysql database? Hi, How much storage space do Game scripts in the mysql database? I'm currently thinking of getting a hosting package with 100mb of database storage, will that be enough? thanks for any advice. vizplay

10-12-2007, 06:05 PM	#3 (permalink)
RickyG Moderator Senior Member Join Date: Dec 2006 Location: Under Your Mouse! Posts: 1,208	Datebase storage or space? Sql is a lot smaller than the SWF's for an arcade site. RickyG __________________ Arcade Banner Exchange, game packs, top site, arcade script and forum for all of your arcade needs http://www.mibbi.com This site stinks!! www.farting.us Coming soon MibbiJr!

10-13-2007, 01:07 AM	#4 (permalink)
brendgard Gamer FX Staff Senior Member Join Date: Oct 2006 Posts: 681	I've seen MySQL databases with 30,000 entries that take up just over 2 megs. for an arcade, 100 megs database space is more than enough to start out with. If you're talking main disk space though, that's another story. 100 megs won't even begin to cover it for an arcade's main diskspace. __________________ http://gamersgo.com A list of arcade related sites, add yours. http://auntiefondy.com Lists, add your site. http://kbsplace.com

10-13-2007, 05:14 AM	#5 (permalink)
RickyG Moderator Senior Member Join Date: Dec 2006 Location: Under Your Mouse! Posts: 1,208	2 megs DB is still small. I have seen larger DB for things like blogs or forums, cause all lthe posts become the db. As far as an arcade DB goes.... small. Even whith users signing up, it is only 1 line of (text) DB. __________________ Arcade Banner Exchange, game packs, top site, arcade script and forum for all of your arcade needs http://www.mibbi.com This site stinks!! www.farting.us Coming soon MibbiJr!

10-13-2007, 10:03 AM	#8 (permalink)
RickyG Moderator Senior Member Join Date: Dec 2006 Location: Under Your Mouse! Posts: 1,208	Now that I am home on the lappie, let me try to explain further....kinda tough on the Black Berry....LOL! A SQL file for a forum holds all the posts. Depending on how many posts, lenghth, and memebrs wil make the SQL large(R). If you own a phpbb of joomla or a off the shelf php app, you dont need to DL the whole site for a BU. You only need 2 things. 1- sql <> this wil have all posts and such 2- any "special" template files and logo. With that you can go to any server and rebuild your site. A few clicks with fantasico and the SQL ...ALL DONE. Now that I said all of that...an arcade in comparsion takes little SQL database. It needs some simple command lines to tie in the SWF/Thumb/link. It also contains the data for users. Now, remeber.....a SQL for an arcade site can be large, if there is any type of blog, forum, or anything tied to it. Just like a song site I have. It has over 100,000 full length song lyrics. That DB is 251 meg in size. If it was just song titles, it migth be a few K in size. The qusetion asked above was on an arcade site.. RickyG __________________ Arcade Banner Exchange, game packs, top site, arcade script and forum for all of your arcade needs http://www.mibbi.com This site stinks!! www.farting.us Coming soon MibbiJr!

10-12-2007, 04:39 PM	#2 (permalink)
microjoes Preferred Member Join Date: Jun 2007 Posts: 160	100mb is ok. A data base can get very big after users register and make comments and use the other features. Over time the database will grow but 100 mb is more than enough to start.

10-18-2007, 12:16 PM	#9 (permalink)
john274 Full Member Join Date: Aug 2007 Posts: 97	It depends really on the database setup and how many indexes it has as well. If you are just talking about the database then an active site would eventually need more than 100mb's, but that would take a while to get that amount. If you are talking about the games hosted on your server as well then you will probably be able to have around 150 games that are on average 500kb's each. __________________ Free Online Games \| Funny Videos \| Funny Pictures Providing you with some of the best humor on the web which is updated daily!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
FREE 65 Video Database Dump	SKULL	Content	0	09-09-2007 12:23 PM
convert database	2GrandArcade	Webmastering	3	04-06-2007 06:25 PM
$525+/monthly revenue. Gamepacks.org - Arcade/Media supplier up for auction.	allstar	The Bazaar	0	03-01-2007 11:11 AM
[Wanted] The following ArcadeScripts mySql Databases.	allstar	Arcades for Sale	4	10-11-2006 07:57 PM