Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Author: admin
Split a query results multiple times
Question : I need to create a procedure to make statistics on my database. First, I decided to create a […]
Improve reading speed of MySQL table storing stock prices (100 Mil. entries)
Question : I have a table which stores stock prices in a MySQL database with the following structure: CREATE TABLE […]
Adding sql users via linked servers
Question : I need to add a windows user and set role to sysadmin for a bunch of linked servers […]
Postgres – caching of recently inserted data?
Question : Does Postgres cache recently INSERTed data? And if so, how can I increase the amount? Here’s why I’m […]
Does Oracle randomly switch execution plans to check if there is a better solution?
Question : I had a talk with an external colleague about oracle “swinging in” its performance. In detail it was […]
Cannot INSERT into database on a shared server
Question : I have launched an application on a shared server but I cannot INSERT any data. I thought maybe […]
Simple query with a single join very slow
Question : I have this very slow, simple query that joins a large table (~180M rows) with a smaller table […]
How to replicate and sync MongoDB localhost to a remote server using replica set
Question : Initially I started two node(primary and secondary) on same host machine on two different port , secondary was […]
How can I increase performance for select in select statement
Question : The item table is like this id category_id name registered I have to show total number of items […]