I have a MySQL query that searches through a zipcode database for city names. The query takes about 4 seconds, to search through 620,000 zipcodes. I would like ideas how I can make this faster. First, the tables: I have…
Using MySQL 5.7, I have a table of urls containing url_title, url_description, url_keywords Sometimes I just need to look in url_title, but sometimes look for something in all columns. Is it better to just create one index containing all 3…
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…