• Resolved arhamm

    (@arhamm)


    I run an ecom site where I buy, refurbish and sell used electronics like cameras, consoles, phones.

    I have a wordpress site that I use to manage and track all the products. The site is only used internally and is firewalled to all outside traffic.

    I have a custom post type for each product, cameras under “camera”, console under “console”…etc

    All the post types are pretty much the same, they have pretty much the same fields, the value of those fields might be different. One example “make” and “model”. Both are lists, different products have different make and models.

    Im adding around 300 new posts a month, 200-250 are cameras, and the rest are other post types. Cameras are the most popular products and I have around 2100 posts. 2nd most popular are consoles with around 900 posts. All the other ones have a few hundred each.

    My issue is that cameras take very long to load, close to 60 seconds, all other products 3-5 seconds.

    I can load as many posts at the same time from other post types and the site wont run out of ram but I have to load one camera at a time or the site runs of memory and crashes.

    The site is running on 16GB ram. I have 17 pods, 36 groups and 686 fields.

    Anything I can do to fix this or do I simply have too many posts?

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    Do you have any details on the camera post type configuration? Perhaps you can provide what template you are using to output that or the Pod configuration for that specific pod?

    Thread Starter arhamm

    (@arhamm)

    Please find below my template. One thing I should clarify, loading a page is not that slow, what is really slow is updating posts where the post type is camera.

    Adding a new post “camera” is often very slow too. If I’m adding a post and load any other post at the same time the site runs out of ram.

    {
        "@meta": {
            "version": "2.9.10.2",
            "build": 1675196118
        },
        "templates": [
            {
                "name": "Camera",
                "code": "{@pending_on}\r\n<form method=\"post\">\r\n\t\t<input type=\"submit\" name=\"list\" value=\"List\"\/>\r\n\t\t<input type=\"submit\" name=\"update_onbuy\" value=\"Update OnBuy\"\/>\r\n\t\t<input type=\"submit\" name=\"update_titles\" value=\"Update Titles\"\/>\r\n\t\t<input type=\"submit\" name=\"update\" value=\"Update\"\/>\r\n\t\t<input type=\"submit\" name=\"update_google_shopping\" value=\"Update Google Shopping\"\/>\r\n\t\t<input type=\"submit\" name=\"update_pricing\" value=\"Update Pricing\"\/>\r\n\t\t<input type=\"submit\" name=\"update_descriptions\" value=\"Update Descriptions\"\/>\r\n\t\t<input type=\"submit\" name=\"update_images\" value=\"Update Images\"\/>\r\n\t\t<input type=\"submit\" name=\"update_attributes\" value=\"Update Attributes\"\/>\r\n\r\n<\/form>\r\n<br>\r\n[pre_listing_checks]\r\n[list_products_on_site]\r\n[update_products_on_site]\r\n[amazon_fba_inventory_event_report]\r\n[get_xero_invoice_id]\r\n\r\n{@order_number_sale}\r\n\r\n<h3>Approved for Listing? {@approved_for_listing}<\/h3>\r\n<p>{@reason_for_the_item_not_being_approved}<\/p>\r\n<h3>Listed? {@listed}<\/h3>\r\n<h3>Sold? {@sold}<\/h3>\r\n<h3>FBA? {@fba}<\/h3>\r\n<h3>Added to Shipping Plan? {@added_to_shipping_plan}<\/h3>\r\n<h3>Checked in fba? {@checked_in_fba}<\/h3>\r\n<h3>Returned? {@returned}<\/h3>\r\n<h3>Reimbursed? {@reimbursed}<\/h3>\r\n<h3>On Hold? {@on_hold}<\/h3>\r\n<h3>Archive? {@archive}<\/h3>\r\n<h3>Needs Repair? {@repair}<\/h3>\r\n<table>\r\n\r\n    <tr>\r\n        <td>Post ID<\/td>\r\n        <td>\r\n            <p id=\"ID\">{@ID}<\/p>\r\n        <\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Make<\/td>\r\n        <td>{@make}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Model<\/td>\r\n        <td id=\"sku\">{@model}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>SKU<\/td>\r\n        <td>\r\n            <p><\/p>\r\n        <\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>SKU<\/td>\r\n        <td>\r\n            <p id=\"amazon_sku\">{@sku}<\/p>\r\n        <\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Serial Number<\/td>\r\n        <td>{@serial_number}<\/td>\r\n    <\/tr>\r\n\r\n\r\n    <tr>\r\n        <td>Order Number<\/td>\r\n        <td>{@order_number}<\/td>\r\n    <\/tr>\r\n\r\n    <tr>\r\n        <td>Condition<\/td>\r\n        <td>{@condition}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Description<\/td>\r\n        <td>{@description}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Amazon Description<\/td>\r\n        <td>\r\n            <!-- <input type=\"text\" value=\"{@amazon_description}\" id=\"amazon_description\"><br> -->\r\n            <div id=\"amazon_description\">{@amazon_description}<\/div>\r\n            <!-- <button onclick=\"Copy_Descrption()\">Copy Description<\/button> -->\r\n            <a href=\"#\" onclick=\"CopyToClipboard('amazon_description');return false;\">Copy Text<\/a>\r\n\r\n        <\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Marketplace<\/td>\r\n        <td>{@marketplace}<\/td>\r\n    <\/tr>\r\n<\/table>\r\n<table>\r\n    <thead>\r\n        <h3>PROFIT<\/h3>\r\n    <\/thead>\r\n    <tr>\r\n        <td>COGS<\/td>\r\n        <td>{@cogs}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Selling Fees<\/td>\r\n        <td>{@selling_fees}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Shipping Costs<\/td>\r\n        <td>{@shipping_costs}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Revenue<\/td>\r\n        <td>{@revenue}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Profit<\/td>\r\n        <td>{@profit}<\/td>\r\n    <\/tr>\r\n\r\n    <tr>\r\n        <td>Expenses<\/td>\r\n        <td>{@expenses}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Fees Not refunded<\/td>\r\n        <td>{@fees_not_refunded}<\/td>\r\n    <\/tr>\r\n\t   <tr>\r\n        <td>Any Other Costs<\/td>\r\n        <td>{@any_other_costs}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Gross Profit Margin<\/td>\r\n        <td>{@gross_profit_margin}%<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Margin<\/td>\r\n        <td>{@profit_margin}<\/td>\r\n    <\/tr>\r\n\t\t<tr>\r\n        <td>VAT<\/td>\r\n        <td>{@vat}<\/td>\r\n    <\/tr>\r\n\t\t<tr>\r\n        <td>After VAT Profit<\/td>\r\n        <td>{@after_vat_profit}<\/td>\r\n    <\/tr>\r\n\t\t<tr>\r\n        <td>After VAT Margin<\/td>\r\n        <td>{@after_vat_margin}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Date Listed<\/td>\r\n        <td>{@date_listed}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Date Sold<\/td>\r\n        <td>{@date_sold}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>Selling Speed<\/td>\r\n        <td>{@selling_speed} days.<\/td>\r\n    <\/tr>\r\n<\/table>\r\n\r\n\r\n<h3>TESTING CHECKLIST<\/h3>\r\n\r\n<table>\r\n    <tr>\r\n        <td>zoom<\/td>\r\n        <td>{@zoom}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>battery_charging<\/td>\r\n        <td>{@battery_charging}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>flash<\/td>\r\n        <td>{@flash}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>does_it_read_sd_cards<\/td>\r\n        <td>{@does_it_read_sd_cards}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>images<\/td>\r\n        <td>{@images}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>videos<\/td>\r\n        <td>{@videos}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>does_it_come_with_sd_card<\/td>\r\n        <td>{@does_it_come_with_sd_card}<\/td>\r\n    <\/tr>\r\n        <tr>\r\n        <td>sd_card_size<\/td>\r\n        <td>{@sd_card_size}<\/td>\r\n    <\/tr>\r\n            <tr>\r\n        <td>charger<\/td>\r\n        <td>{@charger}<\/td>\r\n    <\/tr>\r\n            <tr>\r\n        <td>batteries<\/td>\r\n        <td>{@batteries}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>camera_bag<\/td>\r\n        <td>{@camera_bag}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>original_box<\/td>\r\n        <td>{@original_box}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>format_sd_card<\/td>\r\n        <td>{@format_sd_card}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>reset<\/td>\r\n        <td>{@reset}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>extra_batteries<\/td>\r\n        <td>{@extra_batteries}<\/td>\r\n    <\/tr>\r\n    <tr>\r\n        <td>shutter_count<\/td>\r\n        <td>{@shutter_count}<\/td>\r\n    <\/tr>\r\n\t    <tr>\r\n        <td>test_buttons<\/td>\r\n        <td>{@test_buttons}<\/td>\r\n    <\/tr>\r\n\t    <tr>\r\n        <td>test_tripod_socket<\/td>\r\n        <td>{@test_tripod_socket}<\/td>\r\n    <\/tr>\r\n\t\t    <tr>\r\n        <td>Autofocus<\/td>\r\n        <td>{@autofocus}<\/td>\r\n    <\/tr>\r\n<\/table>\r\n\r\n\r\n\r\n\r\n<table>\r\n    <tr>\r\n        <td>Serial Number Image<\/td>\r\n        <td>\r\n            <a href=\"{@serial_number_image._src}\" target=\"_blank\" rel=\"noopener\"><img width=\"200px\" src=\"{@serial_number_image._src}\"><\/a>\r\n        <\/td>\r\n    <\/tr>\r\n\r\n\r\n<\/table>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n[audit_log]",
                "id": 5908,
                "sku": "-5908",
                "_edit_lock": "1673029654:2",
                "_edit_last": "2",
                "admin_only": "0",
                "restrict_capability": "0",
                "show_restrict_message": "1",
                "restrict_message": "You do not have access to view this content.",
                "pod_reference": {
                    "pod": "camera"
                },
                "_pods_capability_allowed": [
                    ""
                ]
            }
        ]
    }

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    Oh if it’s during the saving operations, you may want to look at your settings in: Pods Admin > Settings > Performance and turn off metadata overrides or watching.

    Thread Starter arhamm

    (@arhamm)

    That’s already disabled but it’s still very slow

    Plugin Contributor Scott Kingsley Clark

    (@sc0ttkclark)

    Performance is a major priority for me and any time someone encounters slowdowns like this, I want to make sure we get down to the bottom of it.

    If you’d like to join our Live Community Pods Slack at https://support.pods.io/chat/ — I’m sure we can help you debug this more quickly and get to the bottom of the issue. Once you join, just look for me and send me a Direct Message and I can work with you to figure this out.

    Is that something you’re open to?

    Thread Starter arhamm

    (@arhamm)

    Thanks for getting back to me. Sure, I’ll message you on there now.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Performance issues for only one custom post type’ is closed to new replies.