corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » SQL JOIN, UNION?


New Topic

New Poll
  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author SQL JOIN, UNION?
AndyKent
Member

Registered: 3rd Sep 05
User status: Offline
13th Dec 07 at 15:34   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Steve
Battle of the DB queries

i need a dedicated server

i bet the one mines on is hosting 20 vbulletin forums all taking up valuable resources

[Edited on 13-12-2007 by Steve]


Have you looked into dedicated hosting at all? I've been considering it but have no idea what is good or bad, nor do I have £50 a month to spend on it
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
13th Dec 07 at 15:38   View Garage View User's Profile U2U Member Reply With Quote

not really looked into cost, ians probably better to comment on that
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
13th Dec 07 at 15:53   View Garage View User's Profile U2U Member Reply With Quote

Ours is a little over 150pm I think but that is for 2U. Cheaper if you only need 1U of chassis.

I'm sure leasing a server is cheaper than buying as well when you factor in total cost.

50pm for your own leased hardware is not a bad price.
AndyKent
Member

Registered: 3rd Sep 05
User status: Offline
13th Dec 07 at 16:18   View User's Profile U2U Member Reply With Quote

Not so much that it isn't a good price, but more that the site wouldn't support itself (to start with at least) and I can't afford to pour money into it.....

Nor do I understand what I want, lots of bandwidth, little hosting space, middle both, or the other way round completely. Nor do I know how different hardware set-ups will perform. I just know I want PHP and MySQL support, other than that, I think I need to do a lot of research......
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
13th Dec 07 at 19:28   View Garage View User's Profile U2U Member Reply With Quote

If you co-locate you get as much space as your server has hard drive.

Modern hardware isn't expensive. I would imagine if you set up a lease deal at the moment you would probably end up with a spec comparable to the three year old CS machine in terms of its ability to turn requests around.
AndyKent
Member

Registered: 3rd Sep 05
User status: Offline
13th Dec 07 at 19:30   View User's Profile U2U Member Reply With Quote

I have a scout about, see whats on offer

  <<  1    2  >>
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Need a good MySQL host Matt H Geek Day 3 1042
14th Feb 05 at 22:08
by John
 
SQL Server Bart Geek Day 1 846
1st Feb 07 at 16:44
by Samls
 
sql/forms builder help - pretty basic really Tantastic Geek Day 6 682
28th Mar 07 at 18:06
by Tantastic
 
XML/PHP Laney Geek Day 6 807
26th Apr 07 at 15:03
by Ian
 
FAO: Programmers barteh Geek Day 6 808
6th Nov 07 at 14:02
by barteh
 

Corsa Sport » Message Board » Off Day » Geek Day » SQL JOIN, UNION? 29 database queries in 0.0138059 seconds