Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
hall
New Member
New Member



Joined: Aug 08, 2006
Posts: 14

PostPosted: Wed Aug 09, 2006 5:15 am Reply with quote

Hi there, First I was using php nuke 7.9 but everywere I read don't do it. So now I installed rwsRavenNuke76_v2.02.02_FULL and everything seems to be working fine. Anyway I still have 2 question.

After installing the IP2COUNTRY Data into my database into the nuke__nsnst_ip2country table my database got upto 6.44 mb. Now this may sound strange but I am new to databases etc. Question: when I was using nuke without sentinel my databse still didn't even get upto 5 mb after using it for a year now with 50 subscribers. So the question is, how big can a database get before a server/provider says he your database is getting to big ? and second, to limit the size of the database would i not be smarter to write the IP2COUNTRY Data into a seperate file like a txt/csv or html file ?
 
View user's profile Send private message
jakec
Site Admin



Joined: Feb 06, 2006
Posts: 3048
Location: United Kingdom

PostPosted: Wed Aug 09, 2006 5:51 am Reply with quote

The maximum allowable size of your database will be depend on the company who hosts your site. For instance I'm with 1and1 and they limit the size to 100MB.
The speed of your site maybe affected as the database grows.

I'm by no means a database, or PHP expert, but I suspect if you locate the data anywhere else other than the database, it may take your site longer to access it. I suspect one of the experts here will be able to give you a more definitive answer.

Jakec
 
View user's profile Send private message
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6432

PostPosted: Wed Aug 09, 2006 8:16 am Reply with quote

If the database is designed and indexed properly, having more data shouldn't impact performance, especially as compared to using a text / csv file (I wouldn't recommend trying this - a lot of work for little or no benefit).

Normally, if you aren't using IP2Country, you don't need to install it, but there seem to be issues with NukeSentinel 2.5+ if IP2Country isn't installed.

_________________
I search, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
evaders99
Former Moderator in Good Standing



Joined: Apr 30, 2004
Posts: 3221

PostPosted: Sun Aug 13, 2006 10:29 am Reply with quote

I have databases with hundreds of megs of data... no problem. Really IP2Country isn't that big a deal, depending on your host's SQL server, it should be able to handle it. Mostly it is load on the database server, not just the space, that you'll want to look into. My dedicated server is not sharing a database with anyone else, so it is really quite fast.

_________________
- Star Wars Rebellion Network -

Need help? Nuke Patched Core, Coding Services, Webmaster Services 
View user's profile Send private message Visit poster's website
probador
New Member
New Member



Joined: Apr 20, 2006
Posts: 24

PostPosted: Tue Aug 29, 2006 1:04 pm Reply with quote

IT looks like you can delete all the entries of IP2Country except for the IANA Reserved ones.

This has been addressed:
[ Only registered users can see links on this board! Get registered or login! ]
 
View user's profile Send private message
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©