I have this query: Explain select SQL_NO_CACHE p.id as product_id, p.price_amount, p.is_male, p.is_female, p.is_accessories, p.is_contact_lens, c.id as color_id, b.name as brand, p.name, c.color, c.code, c.pohoda_sku, c.on_stock, c.not_send_to_kiosks, (p.is_active && !p.is_archive && c.is_active && !c.is_archive) as is_active, c.is_visible, c.abbr from product_colors…
How do I get the rows for each year by scenario that are associated to the latest scenario for each year while being at-most prior month (future budgets & forecast scenarios exist as well) Fields: scenario (VARCHAR) Distinguishes between budget…
I have a deeply nested JavaScript object structure representing a hierarchical data model. The object can have multiple levels of nested children, and I need to search for a specific value within this structure. Here is an example of such…
I'm using MySQL database. I have to join two tables (A, B). They have relationship (N->N). Actually, A is chatting room table and B is chat (chat record). Chatting room has many chats. If a user enters chat app, the…
I need help optimize below postgresql query. Currently its taking more than 3 min to get the data , due to that my API got timeout ,can you please help me to get the result set within 59 seconds. Thanks…
I'm seeking help regarding full-text searching in MySQL. I have two tables, Article and Keywords. Article: id int, description (varchar(600)) Keyword: id int, value (varchar(50)), article_id int An article can have multiple keywords. For example: id:1, keyword1, article_id: 1 id:2,…
uint8_t data[] = "mykeyxyz:1234nky:123n...";. My lines of string has format key:value, where each line has len(key) <= 16 guaranteed. I want to load mykeyxyz into a __m128i, but fill out the higher position with 0. The easiest way is to…
I want to have X amount of std::vectors of equal size, which I can be processed together in a for loop which goes from start to finish in a linear fashion. For example: for (int i = 0; i <…
I have several queries along the lines of: INSERT INTO my_data_archive.my_table (id, FieldName, Value, Position, PageId) SELECT id, FieldName, Value, Position, PageId FROM my_data.my_table WHERE PageId IN (SELECT id FROM my_data.page WHERE PageTypeId BETWEEN 33 AND 36 AND Deleted IS…
In Azure SQL database, the same query is completed in 4 seconds when Row Level Security is active, and in 1 second when Row Level Security is disabled. When I compared the execution plans of the queries, I found that…