Question : I’m working on a project which is parsing data from measurement files into a Posgres 9.3.5 database. At […]
Category: Performance
Index isn’t used when value is a result of a subquery or from a wrapper query
Question : I have a simple one-to-many relationship: accounts and events where an account may have many events. accounts id: […]
SQL Server – quite big data flow – Disk became the bottleneck … what now?
Question : After a lot of searching & follow up of the system we are getting out of ideas to […]
SQL Server Backup and Query Execution
Question : Is SQL Server Backup affects the query execution performance? Is there an effect while running the SQL Server […]
How to enhance the SQL query performance for thousands and millions of huge data
Question : Now Our team are involved in a forum data analysis project. Its target data is so huge(I think). […]
Better way to full text query across multiple tables?
Question : I’ve got a rather large query across multiple tables and their fulltext-indices which (unsurprisingly) is rather slow: SELECT […]
Is making 2 sequential request to server for every webpage better than implementing server to make subqueries with every request?
Question : Design A: Make server do more work Given a client url in such format www.mywebsite.com/profile/[username], its page generates […]
Is clustering a table beneficial, given this update pattern?
Question : I have a table essentially equivalent to this example: create table my_table(i integer, x text, y integer, z […]
What is the best storing device for DB transaction log?
Question : I’m using MySQL with InnoDB storing engine. Transactional log is placed to dedicated HDD. Still as it is […]
Optimizing complex join predicates [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]