jaymc Posted January 16, 2007 Share Posted January 16, 2007 I have some chatroom software which ive acquired and I'm in the middle of modding it up to add a ban feature and a few profile featuresIn doing this I've had to add 2 extra queries in a script that refreshes ever 3 secondsSo, its 2 queries X num of people online every 2 secondsIm just wondering, will this be a server killed?My server is my own and I dont host people, 2x Opteron 2403Gig RamI know mysql is great and fast but is it asking too much to run a chatroom that will be running about 5 queries every 3 seconds for each member online? Quote Link to comment Share on other sites More sharing options...
trq Posted January 16, 2007 Share Posted January 16, 2007 Do you really need a database? I meen do you plan on storing these chats for any longer than the current session? Quote Link to comment Share on other sites More sharing options...
boo_lolly Posted January 16, 2007 Share Posted January 16, 2007 how's your bandwidth? Quote Link to comment Share on other sites More sharing options...
ki Posted January 16, 2007 Share Posted January 16, 2007 if you worried about your database us a script that deletes any message sent over like a 5 hour time period. Quote Link to comment Share on other sites More sharing options...
jaymc Posted January 16, 2007 Author Share Posted January 16, 2007 Yeh the chat is optimized to delete redundant entriesIm just wondering if the actually query itself will cause issue Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.