Jump to content

lyndsiesal

Member
  • Content Count

    64
  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thanks, @bsmither All of my indexes say "OK" so I have no idea what the problem is with this one site. I have a few other CC shops on the same server with no issues but of course they don't have monster databases. Hmmmm
  2. Does anyone happen to know if there is a guide to indexing the tables?
  3. My store is a download store so the orders and download records are in the millions. I switched from an older dedicated server to a new VPS about a year ago, hoping for some improvement but no luck. The other thing I'd like to try to do is find a way to identify and delete possible orphaned download and order records. Maybe the database is getting stuck looking for something that might not be there? I just don't know. My downloads table has 1,299,799 records and order inventory is at 1,300,401. I don't know if that discrepancy is significant or not but they should match considering
  4. Is there a way to see when the last time a customer logged in was? My database is 10+ years old and I've managed to delete customer accounts who had 0 orders and were older than 1 year but I'm still left with nearly 80K customer accounts. I think it would be great if I could reduce my database further by deleting customer accounts who have not logged in in the past 5 years or so. My database lags so badly that I can't view statistics or do any type of exports and I'd really like to start exploring ways to pare it down.
  5. I already have a mailchimp popup on my shop's index page. Could this popup show up in the catalog pages and not the homepage?
  6. Is anyone else having an issue with missing transaction logs? I sell a digital product that customers expext instantly. a good number (but not all) of my PayPal transactions are not showing up in the transaction logs and the orders are stuck in pending. The IPN history on PayPal's site shows the missing transactions. This came out of the blue yesterday -- no changes have been made to the site.
×
×
  • Create New...