I'm paying for my hosting and with the package it says I get 20 x1gb databases (I've only used 2% of one of them) with low contention (I don't know what that means) so I don't think that's the case, or at least I hope that's not the case.
I'm need to request a lot of information from the database because I'm working on a site that compares various products so there's a lot of filters that people can search via. Without any of those filters working I'm using this to get the results from the database (multiple tables need to be searched):
$query = "SELECT * from feeds, product_categories_map, timing, flavour, source, dietary, ingredients, sweeteners, type WHERE %s %s %s feeds.price >=%s and feeds.price <=%s and feeds.enabled=1 and feeds.stock=1 and feeds.deleted=0 GROUP BY feeds.product_name ORDER BY `%s` %s %s";
$query = sprintf($query, $brand_added, $weight_added, $freesearch, $_GET['budgetFrom'], $_GET['budgetTo'], $_GET['sortedBy'], $_GET['sortDirection'],$sql_limit);
$product_results=dbselect( $query,"dbLinkInt" );
I've changed the mysql_close() to mysqli_close() now so hope that will prevent the connection from being open?
I'm getting desperate to get this working and am really grateful for you helping with this.