best host for db hosting

monaghan · 18-11-2011, 07:46:00 PM

Quote:

Originally Posted by SecNam

sorry for delay in answering.

i am on cloud hosting, 4gb ram, 3cpu etc so there is only me on it and only affects me. products is just over 1 million (as using feeds from affiliate window) and also using price tapestry.

Sounds like you need to spend a little time optimising the database and the queries that are run on it. Also check your SQL Server settings, you may be able to do much more with it. Look at index use, slow queries and so on.

As mentioned above, throwing hardware at an inefficient database will not solve anything for long.

SecNam · 18-11-2011, 08:03:53 PM

Quote:

Originally Posted by monaghan

Sounds like you need to spend a little time optimising the database and the queries that are run on it. Also check your SQL Server settings, you may be able to do much more with it. Look at index use, slow queries and so on.

As mentioned above, throwing hardware at an inefficient database will not solve anything for long.

yeah jimm is having a peak for me so fingers crossed all will be ok

aquanuke · 18-11-2011, 11:29:00 PM

Theres a nice mysql script that will check all your settings, like query cache, slow queries etc etc if you have alot of slow queries then sure sign your indexes are not good.

http://day32.com/MySQL/

The top link

SecNam · 18-11-2011, 11:34:23 PM

Quote:

Originally Posted by aquanuke

Theres a nice mysql script that will check all your settings, like query cache, slow queries etc etc if you have alot of slow queries then sure sign your indexes are not good.

http://day32.com/MySQL/

The top link

great stuff, will look at that. thanks.....

aquanuke · 18-11-2011, 11:37:06 PM

oh and if you do alot of searching make sure you use FULLTEXT search

http://dev.mysql.com/doc/refman/5.0/...xt-search.html

monaghan · 18-11-2011, 11:47:59 PM

Quote:

Originally Posted by SecNam

yeah jimm is having a peak for me so fingers crossed all will be ok

He seems to know what he's talking about, so all should be good, I'd have offered, but I've been shifting kitchen worktops and cupboards ready for the plumber to move my sink

SecNam · 19-11-2011, 12:01:22 AM

Quote:

Originally Posted by monaghan

He seems to know what he's talking about, so all should be good, I'd have offered, but I've been shifting kitchen worktops and cupboards ready for the plumber to move my sink

yeah he certanly does and no prbs mate.

just hoping i get this sorted tbh

jimm · 19-11-2011, 07:53:05 AM

Quote:

Originally Posted by monaghan

He seems to know what he's talking about,

You will make me blush lol

18-11-2011, 11:29:00 PM	#13 (permalink)
aquanuke Join Date: May 2005 Location: Surrey Posts: 1,993 No Classified Ratings Domain Trader Rating: (100% / 20)	Theres a nice mysql script that will check all your settings, like query cache, slow queries etc etc if you have alot of slow queries then sure sign your indexes are not good. http://day32.com/MySQL/ The top link __________________ Dropcatching and DAC hosting - I gotta have More Cowbell - Now I do

18-11-2011, 11:37:06 PM	#15 (permalink)
aquanuke Join Date: May 2005 Location: Surrey Posts: 1,993 No Classified Ratings Domain Trader Rating: (100% / 20)	oh and if you do alot of searching make sure you use FULLTEXT search http://dev.mysql.com/doc/refman/5.0/...xt-search.html __________________ Dropcatching and DAC hosting - I gotta have More Cowbell - Now I do

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	Domain Name Community	Replies	Last Post
1 Search Host offers Free Domains, Professional Web Hosting Plans ... - 1888 Press Re	RSS	Domain Name News	0	10-02-2009 10:59:04 AM
Host Color Web Hosting Provider Announced the Release of Domain ID ... - Greatrespond	RSS	Domain Name News	0	07-11-2008 06:59:06 PM
Aventure Host Launches Free 2GB Hosting Service and Free Domain Names - webhostdir.com	RSS	Domain Name News	0	17-04-2007 04:59:07 PM
Web Hosting Tutorial Firm, DemoWolf, Premieres Domain Transfer ... - WebSite Host Directory (press release)	RSS	Domain Name News	0	15-03-2007 04:59:10 PM
Host Department Announces NOLIMIT Domain Hosting - WebHosting.Info	RSS	Domain Name News	0	21-09-2006 05:59:03 PM