I am implementing an entity-attribute-value model to store nationwide property data that will be updated daily: 130 million properties, will probably store billions of values. We also want to search this data on arbitrary attributes, hence using EAV so we…
I use the EAV (Entity-Attribute-Value) pattern in an inventory management system I'm developing. It's very comparable to a typical webshop framework like Magento. Attributes have a data type, like numeric, varchar, text. The attribute definitions are stored in one table…
i have a table named tblcustomfieldsvalues where i want to create a trigger for updating a row in the same table, this is the table : Table screenshot The goal is to create conditions like this : if the corresponding…
I have a vehicle table with many rows. Every vehicle is stored with a name, and then additional characterizing attributes. Let's say name PRIMARY KEY attr_1 attr_2 attr_3 attr_4 etc... The user can search via a web form by name…
I added a new field in the Magento 2 backend for the customer which is visible. I created this using mage2gen but whatever i try, the new field is not being saved when i update it in the backend. Since…
Just wondering why the following script seems to to add the new records to eav_attribute and catalog_eav_attribute yet the attribute doesn't show up in the admin when I edit a product: <?php /** * Copyright © 2016 Magento. All rights…
I have created MySQL data model to store content along with its custom attributes/field. Below is a simplified version of it. One for storing content: CREATE TABLE `cms_content` ( `id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `content_type_id`…
I have implemented an EAV model using MySQL (phpmyadmin) for an e-commerce website developed with CodeIgniter Framework (PHP). The EAV Model goes this way: Table: Products id | name | description ------------------------- 1 | prod_1 | lorem 2 | prod_2…
I have the following query which gets order data, works fine but takes 13.63 seconds: SELECT ( SELECT meta_value FROM `myprefix_postmeta` as postmeta WHERE postmeta.meta_key = '_sku' AND postmeta.post_id = woocommerce_order_itemmeta3.meta_value ) AS sku, woocommerce_order_items.order_item_name AS title, SUM( woocommerce_order_itemmeta.meta_value )…
I have searched the internet in many places to find some answers to problems in the database of a Magento installation. The website is not available at such a moment (lasting most of the time about 15 minutes and resolves…