Thread: Database limit?

Results 1 to 5 of 5
  1. #1
    Join Date
    May 2010
    Posts
    83
    Plugin Contributions
    0

    red flag Database limit?

    Hi,

    What will happen if the product database gets too big? Is there a limit?

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Database limit?

    There is not a ZenCart limit
    Your host may have a limit or not
    Zen-Venom Get Bitten

  3. #3
    Join Date
    May 2010
    Posts
    83
    Plugin Contributions
    0

    Default Re: Database limit?

    Thanks for your reply. Recently, some product listings become blank. All the previously filled details (product name, price, description, quantity, weight...) disappeared except the image link and product attribute. This seems to happen randomly but probably more often lately. Hence I suspected the database is getting too big and randomly deleting product details when new products are added, is that possible?

  4. #4
    Join Date
    Jul 2012
    Posts
    16,735
    Plugin Contributions
    17

    Default Re: Database limit?

    Quote Originally Posted by waterbender View Post
    Thanks for your reply. Recently, some product listings become blank. All the previously filled details (product name, price, description, quantity, weight...) disappeared except the image link and product attribute. This seems to happen randomly but probably more often lately. Hence I suspected the database is getting too big and randomly deleting product details when new products are added, is that possible?
    More than likely and it is hard to tell/discuss properly because there is no information provided about your ZC setup you are using an older version of ZC 1.3.9 or below and your host has upgraded the PHP version. Has anyone tried to edit the product that seems to have randomly disappearing content?

    The real question though is what is the setup for the system involved? Please try to answer the questions of the posting tips.

    As to dropping information on a "get full" basis, random information loss would not make sense in a design, but instead things like: first in first out, or last in first out, but random information in the middle? Would sound like a poor design... Here you can use this database, but done count on anything in particular remaining in it...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database limit?

    Could also be a character-set issue in the database. Please click Reply below, and answer all the Posting Tips questions which appear above the box where you type your reply.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. v152 How can copy some products from database to another database ?
    By dmagic in forum General Questions
    Replies: 5
    Last Post: 2 Jul 2018, 02:54 PM
  2. Manually merging 151 database customer records into a 154 database
    By jmocallghan in forum Upgrading to 1.5.x
    Replies: 9
    Last Post: 28 Feb 2015, 01:31 PM
  3. Zone Rate Character Limit - Change in Database?
    By panicrecords in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 15 Apr 2010, 04:51 AM
  4. integrate/map new Mysql database with existing zencart database
    By omerhanif in forum General Questions
    Replies: 0
    Last Post: 18 Jan 2010, 12:36 PM
  5. Replies: 2
    Last Post: 12 Aug 2008, 05:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR