I have a query. It has an index but I'm not sure why it's taking time for fewer rows. Can anyone please suggest to improving that query performance? SELECT up.id post_id, c.id community_id, SUBSTRING(up.description, 1, 30) post_description, c.name community_name, c.is_index…
Given a database table events with columns: event_id, correlation_id, username, create_timestamp. It contains more than 1M records. There is a problem I am trying to solve: for each event of a particular user display its latest sibling event. Sibling events…
I want to delete data from multiple collection based on ids received using match query from aggregation . Currently in python i am doing like this but it is taking a lot of time to execute . motor is used…
I am trying to execute a query with an ORDER BY clause and a LIMIT clause for performance. Consider the following schema. ONE (id, name) (1 , a) (2 , b) (5 , c) TWO (id, name) (3 , d)…
I'm computing some percentile sales data grouped by product / US state, and the query is extremely slow for a large list of locations (see "dma" in [long list of locations]). The table is around ~15 million rows. SELECT 'us_state'…
I haven't thought about it much until today. Basically I'm in a situation in which I have the same UIImage appear multiple times in my ViewControllers, and I'm not sure what the impact is. class MyObjectA{ private(set) var myName: String…
I didn't think this would be an issue, but as the database I am using continues to grow, I've noticed that the responses from my program are getting slower and slower (which makes sense, more stuff to look through to…
Ok, my question is all about Am I doing it right? if not, what's the best practice? Recently I've used Docker for my project. Currently, I build a new docker image for each version of my project that I want…
SELECT u.ID, u.display_name as name, u.user_email as email, u.user_registered as registered, ( select meta_value from wp_usermeta where user_id = u.ID and meta_key = 'mobileno' limit 1 ) as mobileno, ( select meta_value from wp_usermeta where user_id = u.ID and meta_key…
I am trying to optimize a WordPress website. I already minified some js and CSS files. I already tried compressing images and videos and trying to eliminate render-blocking files but the website speed is just the same. The issue that…