Jump to content

avyona

Member
 View Profile  See their activity

  • Posts

    44

  • Joined

  • Last visited

 Content Type 

Posts posted by avyona

    Customer Account Pages SLOW

    in Technical Help

    Posted

    I commented it out in the vieworder.inc.php and also in the template and it knocked off 4 secs but its still at 11.5 sec :(

     

    its showing there is a redirect on the download....I'll bet that is the culprit!! Hmmm now where did I add that lol!! off to go dig

     

    Customer Account Pages SLOW

    in Technical Help

    Posted 

    <?php
if (eregi(".inc.php",$HTTP_SERVER_VARS['PHP_SELF']) || eregi(".inc.php",$_SERVER['PHP_SELF'])) {
	echo "<html>\r\n<head>\r\n<title>Forbidden 403</title>\r\n</head>\r\n<body><h3>Forbidden 403</h3>\r\nThe document you are requesting is forbidden.\r\n</body>\r\n</html>";
	exit;
}

	$view_order=new XTemplate ("skins/".$config['skinDir']."/styleTemplates/content/viewOrder.tpl");

	$view_order->assign("LANG_YOUR_VIEW_ORDER",$lang['front']['viewOrder']['order_no']." ".treatGet($_GET['cart_order_id']));

	$order = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id WHERE ".$glob['dbprefix']."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix']."CubeCart_order_sum.customer_id=".$db->mySQLsafe($ccUserData[0]['customer_id']));
	
	if($order == TRUE){
		
		//$view_order->assign("LANG_CUSTOMER_INFO",$lang['front']['viewOrder']['customer_info']);
		
		//$view_order->assign("LANG_INVOICE_ADDRESS",$lang['front']['viewOrder']['invoice_address']);
		//$view_order->assign("VAL_INVOICE_NAME",$order[0]['name']);
	  	//$view_order->assign("VAL_INVOICE_ADD_1",$order[0]['add_1']);
	  	//$view_order->assign("VAL_INVOICE_ADD_2",$order[0]['add_2']);
	  	//$view_order->assign("VAL_INVOICE_TOWN",$order[0]['town']);
	 	//$view_order->assign("VAL_INVOICE_POSTCODE",$order[0]['postcode']);
	  	//$view_order->assign("VAL_INVOICE_COUNTRY",countryName($order[0]['country']));
		
		
		//$view_order->assign("LANG_DELIVERY_ADDRESS",$lang['front']['viewOrder']['delivery_address']);
		//$view_order->assign("VAL_DELIVERY_NAME",$order[0]['name_d']);
	  	//$view_order->assign("VAL_DELIVERY_ADD_1",$order[0]['add_1_d']);
	  	//$view_order->assign("VAL_DELIVERY_ADD_2",$order[0]['add_2_d']);
	  	//$view_order->assign("VAL_DELIVERY_TOWN",$order[0]['town_d']);
	 	//$view_order->assign("VAL_DELIVERY_POSTCODE",$order[0]['postcode_d']);
	  	//$view_order->assign("VAL_DELIVERY_COUNTRY",$order[0]['country_d']);
		
		
		//if(empty($order[0]['customer_comments'])){
		//	$view_order->assign("VAL_CUSTOMER_COMMENTS",$lang['front']['viewOrder']['na']);
		//} else {
		//	$view_order->assign("VAL_CUSTOMER_COMMENTS",$order[0]['customer_comments']);
		//}
		//$view_order->assign("LANG_CUSTOMER_COMMENTS",$lang['front']['viewOrder']['customer_comments']);
		$view_order->assign("LANG_ORDER_SUMMARY",$lang['front']['viewOrder']['order_summary']);
		
		$view_order->assign("LANG_PRODUCT",$lang['front']['viewOrder']['product']);
		//$view_order->assign("LANG_PRODUCT_CODE",$lang['front']['viewOrder']['product_code']);
		$view_order->assign("LANG_QUANTITY",$lang['front']['viewOrder']['quantity']);
		$view_order->assign("LANG_PRICE",$lang['front']['viewOrder']['price']);

		
		$products = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_inv WHERE cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id']));

		 
	

		for($i=0;$i<count($products); $i++){
		
		
			if($products[$i]['digital']==1 && ($order[0]['status']>=2 && $order[0]['status']<=3) ){
				// get digital info 
				// Downloadable Product Options by convict -->
				$dpo_config = fetchDbConfig("Downloadable_Product_Options");
				if (isset($dpo_config['status']) && $dpo_config['status']==1) {

					$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_Downloads INNER JOIN ".$glob['dbprefix']."CubeCart_order_inv ON ".$glob['dbprefix']."CubeCart_Downloads.productId =  ".$glob['dbprefix']."CubeCart_order_inv.productId WHERE ".$glob['dbprefix']."CubeCart_Downloads.cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix']."CubeCart_Downloads.optionItem = ".$glob['dbprefix']."CubeCart_order_inv.dpo AND ".$glob['dbprefix']."CubeCart_Downloads.productId = ".$db->mySQLSafe($products[$i]['productId']). " AND ".$glob['dbprefix']."CubeCart_order_inv.id = ".$db->mySQLSafe($products[$i]['id']);
			
					$download = $db->select($query);
		
				} else {
					// original code ->
					$query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_Downloads INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_Downloads.productId =  ".$glob['dbprefix']."CubeCart_inventory.productId WHERE cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix']."CubeCart_Downloads.productId = ".$db->mySQLSafe($products[$i]['productId']);
					
					$download = $db->select($query);
					// <-
				}
				// <-- Downloadable Product Options by convict
				$view_order->assign("VAL_DOWNLOAD_LINK",$glob['storeURL']."/download.php?pid=".$download[0]['productId']."&oid=".base64_encode($_GET['cart_order_id'])."&ak=".$download[0]['accessKey']);
				$view_order->assign("LANG_DOWNLOAD_LINK",$lang['front']['viewOrder']['download_here']);
				$view_order->parse("view_order.session_true.order_true.repeat_products.digital_link");
		
			}

		
			$view_order->assign("TD_CLASS","");
			$view_order->assign("VAL_PRODUCT",$products[$i]['name']);
			//$view_order->assign("VAL_PRODUCT_OPTS",$products[$i]['product_options']);
			$view_order->assign("VAL_IND_QUANTITY",$products[$i]['quantity']);
			//$view_order->assign("VAL_IND_PROD_CODE",$products[$i]['productCode']);
			$view_order->assign("VAL_IND_PRICE",priceFormat($products[$i]['price']));

			$view_order->parse("view_order.session_true.order_true.repeat_products");
		}
///////////////////////////////////////////FREEBIES INCLUDE GOES HERE//////////////////////////////////	
	include("includes/content/free.inc.php");
		
		$view_order->assign("LANG_ORDER_LIST",$lang['front']['viewOrder']['review_below']); 
		
		$view_order->assign("LANG_ORDER_TIME",$lang['front']['viewOrder']['order_date_time']);
		$view_order->assign("VAL_ORDER_TIME",formatTime($order[0]['time']));
		
		//$view_order->assign("LANG_GATEWAY",$lang['front']['viewOrder']['payment_method']);
		//$view_order->assign("VAL_GATEWAY",str_replace("_"," ",$order[0]['gateway']));
		
		//$view_order->assign("LANG_SHIP_METHOD",str_replace("_"," ",$lang['front']['viewOrder']['ship_method']));
		//$view_order->assign("VAL_SHIP_METHOD",$order[0]['shipMethod']);
		
		$view_order->assign("LANG_SUBTOTAL",$lang['front']['viewOrder']['subtotal']);
		$view_order->assign("VAL_SUBTOTAL",priceFormat($order[0]['subtotal']));
		//.: adg_coupon_mod http://www.alexgoldberg.com/cubemods :.
		$view_order->assign("LANG_COUPON",$lang['front']['cart']['coupon']."<br>".$order[0]['coupon_code']);
		$view_order->assign("VAL_COUPON",priceFormat($order[0]['coupon_savings']));
//.: adg_coupon_mod :.
		//$view_order->assign("LANG_TOTAL_TAX",$lang['front']['viewOrder']['total_tax']);
		//$view_order->assign("VAL_TOTAL_TAX",priceFormat($order[0]['total_tax']));
		
		//$view_order->assign("LANG_TOTAL_SHIP",$lang['front']['viewOrder']['shipping']);
		//$view_order->assign("VAL_TOTAL_SHIP",priceFormat($order[0]['total_ship']));
		
		$view_order->assign("LANG_GRAND_TOTAL",$lang['front']['viewOrder']['grand_total']);
		$view_order->assign("VAL_GRAND_TOTAL",priceFormat($order[0]['prod_total']));
	
		$view_order->parse("view_order.session_true.order_true");
	
	} else {
		$view_order->assign("LANG_NO_ORDERS",$lang['front']['viewOrder']['order_not_found']);
		$view_order->parse("view_order.session_true.order_false");
	
	}
	
	
	$view_order->assign("LANG_LOGIN_REQUIRED",$lang['front']['viewOrder']['login_required']);
	
	if($ccUserData[0]['customer_id']>0) $view_order->parse("view_order.session_true");
	
	else $view_order->parse("view_order.session_false");
	
	$view_order->parse("view_order");
	
$page_content = $view_order->text("view_order");
?>

    Here is my vieworder.inc.php file contents and here is an excerpt from the free.inc.php file...Its too long to post but I'll post the queries its pulling.

    <?php
///testing new query
$order = $db->select("SELECT prod_total, time, status, CubeCart_order_sum.customer_id, cart_order_id FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id WHERE ".$glob['dbprefix']."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix']."CubeCart_order_sum.customer_id=".$db->mySQLsafe($ccUserData[0]['customer_id']));

$prod_total = $order[0]['prod_total'];
$time = $order[0]['time'];
$status = $order[0]['status'];



//////////Dec 28-Jan20///////////
if ($prod_total > '4.90' && $time > '1293494401' && $time < '1295600400' && $status > '1') { 
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/sweetheartalpha.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

if ($prod_total > '9.90' && $time > '1293494401' && $time < '1295600400' && $status > '1') {
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iI/pages/dec28promo10.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

     

    Customer Account Pages SLOW

    in Technical Help

    Posted

    how would I go about adding the proper indexing to the database so that when a customer clicks the download link for a product it doesnt take 29 sec to pop the download dialog box?  Is there any code changes or is it all done via indexes certain tables. If so which tables do I add index or PRIMARY KEYs to?  Thanks in advance...sorry to bump this one but I was doing some pings on the downloads and have finally pinpointed what element on the viewOrder.inc.php page that causes such huge delays

     

    Questions about switching to CC6

    in Technical Help

    Posted

    I never even thought of moving my current modded cc3 to a fresh server and then upgrading that install...I ...feel....stupid....now

    1. You can FTP the master images to the /images/source/ folder. Then, in admin, Images, click the Update File List tab. This will load the images into the File Manager system. Once the File Manager has them, then assign the image(s) to the products. Each product can have several images associated with it. This set of associations is maintained in a different table (a 'glue' table for a many-to-many relationship between product_ids and filemanager_ids). The inventory table does not hold any information about the image associations. The requirements of the skin (as listed in the skin's config.xml file) dictate the size variants created 'on-demand' and stored in the /images/cache/ folder.

    2. It is possible to import CC3 data into a CC6 table. But odds are high there will get key relationships messed up. Best to make a copy of the CC3 database and upgrade that.

    There is linking to another database (seems both relatively easy but fraught with unrealized obstacles), but CubeCart allows for table prefixes. Thus, you can have CC6 create its own set of tables, perhaps prefixed by 'cc6_'. Doing that will eliminate quite a number of obstacles to having CC6 query the CC3 database. I can see small changes needed to the Database class, or use the all-purpose class method that does not care what the query is - it just executes it.

    3. The statement you see in the core code about querying for hooks will execute PHP code found elsewhere. In these forums, there are discussions about creating a "code snippet". Search on "code snippet" try a few. Feel free ask questions afterwards.

    4. The info I see about becoming a "seller" on the Marketplace says you need a PayPal account. There is no mention of any exceptions if everything you will want to put in there will be free. Until that gets resolved, I put all my stuff on www.cubecartforms.org.

    5. I have read many reports of store owners saying the Forgot (reset) Password function in CC6 is flaky. I've been through the code dozens of times. Having done that, I've made several suggestions to make the process better, but have not found where a coding problem exists that would cause a reset password not to work. Having said that, I run my dev installs with caching disabled. There are ongoing discoveries of 'weirdness' caused by retrieving recordsets from the query cache when the query should have been sent to the database for a fresh result.

    There are three types of CubeCart passwords: CC3 (no salt), CC4 (one salt), and CC5/6 (three salts with 'new_password' flag).  CC5/6 will/should detect what style the record has and update it accordingly.

    6. I have no idea.

     

    And thank you for the clarification and the time you took to address each point :)

     

    Multi Download Links

    in Technical Help

    Posted

    Oh cool! I would totally pay for the cc5 mod version of multi download prods. Let me know if you find it and PM me.

    The bundle mod I did check it out but each product has 12 formats and that would be hard to pull off haha!

    Multi Download Links

    in Technical Help

    Posted

    Like this one?

    http://www.cubecartforums.org/index.php?showtopic=14341

    Or are you suggesting this for CC6?

    Are you the author of this one? hehe I love this mod!!  I discovered it years after my store went live so I couldnt implement it because it only works on newly created products I believe. I always wanted to use it though. What a great mod and I would ADORE seeing it on cc6!!! So to answer your questions yes I am suggesting it for cc6 ;)

    There used to be a mod for one of the CC versions that did this. I cant remember who put it out. Anyway I thought this would be a helpful means of putting less stress on the server.

     

    There is a mod (I think for V3 and V4) that allowed download files to be associated with product options which you did say wouldnt be as good but we have this working on a couple of client sites and it works well.  There isnt a version for V5 / V6 so it might be something we would look to write

    Ian 

    I remember this mod as well, it is a good one and works well. Our business sells software for embroidery machines. So what happens is the customer is using Singer, for instance, and they switch to Brother sewing machines, then they would have to purchase it again. I get compliments for offering all the sewing machine formats in my downloads. I wouldnt want to change that on them. BUT making those files smaller and in portions would allow them to access any format for any product should the need arise to get another file format due to switching machines.

    Questions about switching to CC6

    in Technical Help

    Posted

    I am in the process of moving my CC3 store into a CC6 store. I have decided not to just simply "upgrade" through admin because I am using CC3 and well the databases are different. I wanted a fresh slate to work from and to test before going live. I have a few questions:

    1. I have thousands of products which I have successfully imported into the new database, except for the image column. Can I FTP images to the source folder and then add then to products?  I noticed the new CC6 generates a few different versions of the images. Several sizes so to speak. I guess what I am asking is when do the extra sizes get generated?  When editing a product and assigning an image to it or during image upload in the admin? I really dont want to have to manually upload one at a time with thousands of images. Having to manually assign them to each product is going to suck already.

    2. Can I also import the order tables, downloads table into cc6 and it be compatible with cc3? Right now I am seeing a few differences. IF NOT, would it be more feasible to simply make the CC3 database be pulled when a customer wants to view a past order (pre CC6). Maybe via a link in their account that reads "2009-2014 Order History" and when clicked it queries the old database. How does one do that by the way lol?  Link to another database?  What kind of php code would I need to use?

    3. How exactly do code hooks work?  I usually edit the core files, although I hate doing this and would love to simple append to existing code.

    4. If I wanted to offer a free mod to the CC6 database, what are the requirements?

    5. Is the forgot password in the new CC6 better than CC3?  I get daily emails (10 a day at least) of customers who forgot their password and the generated one doesnt work. I have to manually reset several passwords a day using someones edit customer cc3 mod.

    6. Where in the world have all the cubecart modders gone?! There are so few mods available. I'm hoping its because less are needed! :)

    Thats all I can think of now. I'm still moving database tables over one at a time.  I DID notice that when I moved customers that the SALT column doesnt exists in CC3 as it does in CC6. I tried logging in with one of the customers from the old database and the SALT was generated so that was good news!!

    Multi Download Links

    in Technical Help

    Posted

    It would be nice to be able to provide multiple download links for one product. I sell zip files or digital downloads. I think this would be an invaluable plugin to reduce server strain because it could dish out one portion of the download instead of one giant file. The customer could select which version to download. Doing it as product options isnt as productive because if the customer changed platforms they would have to repurchase it just to download the new format they need.

    There used to be a mod for one of the CC versions that did this. I cant remember who put it out. Anyway I thought this would be a helpful means of putting less stress on the server.

    Customer Account Pages SLOW

    in Technical Help

    Posted

    The slowness here will have nothing at all to do with php memory, php version (although general speed could be improved by tuning php, apache plus which php handler you use as well as installing a php opcode system) but will be mainly down to poor database design / optimisation as well as unoptimised MySQL server configuration

    Ian

    Ian do you feel that an upgrade to cc6 will be of significant help?

    Customer Account Pages SLOW

    in Technical Help

    Posted

    off topic question...im importing cc3 product catalogue into the cc6 using the import tool.  I dont see an option in the drop down for product id?  Is there a reason or am I missing something?

    Here is what I could find in regards to memory

    phpmem.jpg

    Customer Account Pages SLOW

    in Technical Help

    Posted

    so just take my above quote query and put in the actual values and run it in phpadmin?  I can do that. PHPadmin is my friend! Sorry for the confusion on the version. I would love to switch to cc6 and hope to, I just wanna make sure that something else isnt going on that is causing a horrid problem. Do you think I will be able to import cubecart_downloads and order inv into cc6 despite the size of it and do it successfully?  Or should I just tell my customers that their old orders are bye bye and warn them to download before it all gets wiped?

    Customer Account Pages SLOW

    in Technical Help

    Posted · Edited by avyona

    Hi

    That is a reasonable number of rows but in a correctly indexed table with MySQL that is tuned correctly it shouldnt be any issue and we have clients with stores larger than that.

    What version of CubeCart are you running - versions prior to V6 had quite a lot of missing indexes on tables that can be added to improve query performance.  What tuning of the MySQL server has been done - there is a huge amount that can and should be done when dealing with larger databases. How much memory does your server have ?  When you get to larger sites there is no one answer that fits anyone other than your setup

    One other option of course is to archive out some customers and orders which is another approach we have taken with some of our larger cleints

    Ian

    I'm running cc3 heavily modded...and I mean heavily with tons of my own personal coding.  I have 32 GB of mem on the rack.  How would I go about archiving out orders?  I have already gone through and deleted customers who have 0 orders...that removed like 15k customers, but we still have 75k customers still.

     

    When CubeCart receives a download page request, there are three checks: the order exists and has been paid for, the expire parameters have not been met, and the file to download actually exists.

    If there is any sluggishness in this process, that sluggishness should also show up when the admin is bringing up an order for a summary overview.

    In your hosting control panel, you may have phpMyAdmin to administer the database. Find an order's accesskey from a recent order, then query for the record WHERE accesskey = that_value.

    If the result is not sluggish, we may need to look elsewhere than the database.

     

    Bsmither, yes I get enormous lag in the admin when editing an order, viewing an order. Especially on black friday. I just give up on those kinda days.

     

    A thing to consider is that I run a free.inc.php file attached to the vieworder.inc.php that contains if statements for each week spanning the past 4 years or so. Each week I edit my free.php file to create a new if statement... here is an example. keep in mind there are probably 300 if statements in this file and this is only two of them. Notice how the timestamps bump up to each other. the result is that there is a button at the bottom of the order summary page that can be clicked and a popup window displays download links to free products. Could this be what is slowing things down so badly? I mean I know if doesnt help things, but I'm not sure how else to give customers free downloads of our products cause you can only do one coupon at a time ya know? lol its a friggin mess.

    $order = $db->select("SELECT prod_total, time, status, CubeCart_order_sum.customer_id,
 cart_order_id FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix'].
"CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix'].
"CubeCart_customer.customer_id WHERE ".$glob['dbprefix'].
"CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($_GET['cart_order_id'])." AND ".$glob['dbprefix'].
"CubeCart_order_sum.customer_id=".$db->mySQLsafe($ccUserData[0]['customer_id']));

$prod_total = $order[0]['prod_total'];
$time = $order[0]['time'];
$status = $order[0]['status'];

//////////JUNE23-MADELINE FONT, BANNER ALPHA, COWBOY BIRTH MONTHS'///
if ($prod_total > '4.90' && $time > '1435092677' && $time < '1436208463' && $status > '1') { 
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iIxxxxxx56/pages/
JUNE-23-2015-53GO9.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}
if ($prod_total > '9.90' && $time > '1435092677' && $time < '1436208463' && $status > '1') {
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iIxxxxxx56/pages/
JUNE-23-2015-103V44.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}
//////////JULY 6- BLASTOFF, SPACESHIP, SPACE FONT///////////
if ($prod_total > '4.90' && $time > '1436208464' && $time < '1436831215' && $status > '1') { 
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iIxxxxxx56/pages/
JUL-6-2015-5T3I9.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}
if ($prod_total > '9.90' && $time > '1436208464' && $time < '1436831215' && $status > '1') {
        $view_order->assign("FREEBIE_LINK",$glob['storeURL'].'/2We5t86aCq35iGmfLI1iIxxxxxx56/pages/
JUL-6-2015-10L53T.html');
        $view_order->assign("FREEBIE_NAME",'FREEBIES');
	$view_order->parse("view_order.session_true.order_true.freebies");
}

    i forgot to mention that checkout on my website is horrendous as well. Customers just sit and stare waiting to connect to paypal. Another clue.

    ive already installed cc6.06 on a test domain and server and I am importing things over. Got customers so far. Scared to do products. I guess I want to know if my cc3 store can be fixed or if its time for me to move on to newer venues. I shudder to think that shopify, bigcommerce and the likes of them are my only options. I enjoy tinkering when I want. I have loved cc for years. But I dont dont to waste a lot of time moving everything over to cc6 and then be faced with these monsters all over again. The goal is to improve performance. I would throw more money at at even bigger server, but why?  It should work fine what I have now. 

    Customer Account Pages SLOW

    in Technical Help

    Posted

    I am getting daily reports of customers not being able to download their digital products from their order detail page. They say they click...nothing happens the browser just thinks and thinks. I believe the database is suspect having 492,185 orders in it.  And each of those orders have any number of individual download links. We are running a hostgator top dedicated server. I have already gone through and cleaned up unneccessary code, queries from mods and the like.

     

    Cubecart_Downloads and Cubecart_orderInv each = 2,500,000 rows.

    Cubecart_order_sum = 492,185

     

    What should I do about this?  I believe that the huge number of rows in over inv and downloads is accounting for some serious choking on our website. Using Pingdom tools doesnt help because it doesnt ping account pages etc. I have racked my brain. I must now humble myself and ask, "What would you do with a bulky database like this?" Thanks in advance :)

×
×
  • Create New...