Zikula Community

• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 48

  Posted: Sep 01, 2005 - 05:11 PM

  Hi guys... my name is Aram from www.HealingHQ.com - I had Amazone installed for the first two months - but a few days ago I noticed that our homepage was seriously slow loading.. so much so that I was freaking out - afraid we were losing visitors... so we played process of elimination to find out the culprit and it was Amazone - the blocks on the homepage column (which are now removed) and the Amazone store in general (which is no longer linked to my main menu) -- can someone shed some light on the situation - what happened? Why is Amazone slowing down my site or rather why has it become deathly slow loading.. to the point that I had to de-activate the blocks on homepage and unlink the main store...
  
  thx,
  
  Aram
  
  PS - could it be a memory problem or something like that?
  
  http://www.healinghq.com/AmaZone+home.phtml is the URL of my main Amazone store - if someone could take a look to see why its loading so slowly - thx all!

  • 
  •  
• **unknown user**
  
  

  • Rank: Softmore
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 388

  Posted: Sep 01, 2005 - 07:24 PM

  I am no coder but it could be but not limted to.
  
  Your Server PC.
  The memory.
  The connection to the database.
  The database being all messed up.

  • 
  •  
• jmvedrine
  
  

  • Rank: Helper
  • Registered: Jan 12, 2004
  • Last visit: Jan 20, 2010
  • Posts: 590

  Posted: Sep 02, 2005 - 03:16 AM

  You need to understand the process : AmaZone module get all its data from the Amazon Webservice. If all is working as expected, to avoid contacting Amazon 1 time for each product at each page request, Amazon results are cached by the module in the database.
  The problem is that each page contain links to other related or similar items.
  On my main site http://www.vedrine.net, I have an AmaZone center block on all pages. Recently with a lot of bots (picsearch proved to be the worst of all eating Gigabytes of my bandwidth) crawling my website my AmaZone table has grown to tens of thousands of records, and each records contain the complete description of an Amazon product as an XML string !! This caused a lot of troubles : table corruption, slow page loading, ...
  I was forced :
  - to add a lot of disallow to my robots.txt
  - to ban some unfriendly robots that were not obeying my robots.txt file
  - to frequently purge amazon cache table and unfeatured items table
  This seems to have corrected the situation somewhat
  The long term solution is that AmaZone module's administration panel include a complete administration of products type and nodes so that you can limit the items displayed. Currently an unsmart bot can think that your website has a webpage for each Amazon item (for this reason if you search for "aquarium de jmv", Google will return more than 7000 results, most of them being Amazon items !!
  
  --
  Visit my live reef aquarium.
  
  My Amazon wish list.

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 48

  Posted: Sep 02, 2005 - 12:05 PM

  I guess I am still trying to figure out if the problem is my database or if the problem was with Amazon and will get better - or do I have to do something to get this fixed?
  
  http://www.healinghq.com/AmaZone+home.phtml
  
  maybe someone could take a look at my store and see what they think - for now I have unlinked it from my homepage... thx
  
  aram

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 48

  Posted: Sep 02, 2005 - 12:06 PM

  I just checked my store page - and its loading fast again --- so I guess it was not my database? and things are back to normal? sorry I am such a dope about this...
  
  aram

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 48

  Posted: Sep 02, 2005 - 12:07 PM

  PS - what should the 'max cache time' be set to in the preferences? I think mine was set to 3600 and I changed it to 1000 - not sure why.. I think i was trying to figure out if that helped fix things..

  • 
  •  
• **unknown user**
  
  

  • Rank: Registered User
  • Registered: Mar 16, 2002
  • Last visit: Oct 21, 2009
  • Posts: 48

  Posted: Sep 02, 2005 - 12:45 PM

  http://www.healinghq.com/AmaZone.phtml - correction - this is my store's main page - I am linking it back - I am still hoping someone will update Amazone and make it work with AWS 4.0 - any takers yet?

  • 
  •  
• daddysupa
  
  

  • Rank: Softmore
  • Registered: Dec 23, 2003
  • Last visit: May 05, 2010
  • Posts: 351

  Posted: Sep 09, 2005 - 05:18 AM

  i emailed jmvedrine my module i was working on which is AWS 4.0/pnapi & pnrendered
  
  will have to follow up with him to see how much effort is required to integrate the 2...i.e. Amazone's tremendous detail, and my basic functionality but totally updated.
  
  regards
  
  supa
  
  --
  
  Caribbean News
  Online Shopping from USA, Canada, UK, France, Germany
  On Facebook

  • 
  •  
•  
•  

Users on-line

• internetking,
• slam

This list is based on users active over the last 60 minutes.