Question : After googleing a bit, it’s plainly clear you cannot run vacuum from a function: Postgres mailing – Vacuum […]
Category: Performance
How can we improve this PIVOT operation? ( SQL Server 2008 R2 )
Question : We have this query, that runs in 1:10. We need to improve this. This is just a test […]
copyInSerializer.AddInt32(i)
Question : Answer :
Slow insert in SQL Server 2008
Question : Our products’ database contains an audit trail table: CREATE TABLE gn_AuditTable( gn_ObjectId int NULL, gn_Action smallint NULL, gn_Time […]
Performance of rare SELECT vs. frequent INSERT in timeseries data
Question : I have a simple timeseries table movement_history ( data_id serial, item_id character varying (8), event_time timestamp without timezone, […]
Does Oracle Partition by Reference optimizes join queries
Question : Oracle 11g has a new feature in partitioning tables called partition by reference. I want to know whether […]
Simplify and optimize a complex query
Question : Our site has a chronological event feed that uses MySQL. We have noticed that some of the queries […]
Disk block size for mongodb deployment
Question : Why does Mongodb production notes have no recommendations about the disk block size? AFAIU, disk block size would […]
Do certain string patterns affect query performance on a VARCHAR column?
Question : I am a beginner on MySQL Administration and performance problems. Now this is confusing me. I have a […]
Spike and time out errors every x th minute
Question : I have very complicated situation here. Application team was reporting that they see spikes and errors every 20 […]