query-optimization
Optimization of psql querys called from perl
I have been struggling for a while trying to optimize the time and resources consumed by a couple of querys Im calling from a perl script. The problem is as follows:[详细]
2023-04-01 09:27 分类:问答Multiple Column Index vs Multiple Indexes
I have the following table in a MySQL database: CREATE TABLE `secondary_images` ( `imgId` int(10) unsigned NOT NULL AUTO_INCREMENT,[详细]
2023-04-01 07:22 分类:问答Rotating user stats
Supposing I have a table with the following schema: int pitchId, int pitcherId, int pitchType, timestamp pitchTimeStamp[详细]
2023-04-01 06:49 分类:问答Will forcing `group by` to sort DESC speed up code up, or slow it down?
In MySQL group by does an implicit order by ASC. This is great if you wanted to add an ORDER BY ASC because then the results are already ordered.开发者_StackOverflow社区[详细]
2023-04-01 00:44 分类:问答What is difference in using find_by_sql and our normal rails query method?
I have a small doubt regarding the execution time for MySQL query in my rails application. I have written a query like[详细]
2023-04-01 00:21 分类:问答PostgreSQL Column Index Query Optimization Question
Will the following query be optimizable if I create indexes on latitude*69 and longitude*46? select * from lo开发者_如何学Gocations where abs(latitude*69 - 3036) <= 25[详细]
2023-03-31 15:24 分类:问答MYSQL - Left joins, optimize 2 sec query
I try to optimize my MySQL query, I merged already all tables to one table where it seems useful. But the query still takes over 2 seconds... Is there a way to make it faster?[详细]
2023-03-31 13:03 分类:问答How to optimize a count SQL query on a big table
I have a big table on mysql (innodb) which contains products assets (13 millions of rows). Here a little schema of my database :[详细]
2023-03-31 00:12 分类:问答PostgreSQL query optimization
I have such query and I\'m trying to optimize it. It takes around 1 second to perform. It is somehow performance bottleneck, because it runs few times per second.[详细]
2023-03-30 09:28 分类:问答Hint oracle to use indexes on the subquery -- Oracle SQl
I have a query as follows select * from ( select id,sum(amt) amt from table_t group by id ) t inner join table_v v on (v.id = t.id)[详细]
2023-03-29 07:50 分类:问答