Question : I have an issue where a system on our network is making a query (select * from table) […]
Tag: limits
ORDER BY indexedColumn ridiculously slow when used with LIMIT on MySQL
Question : The MyISAM table has 4.5m rows. Query with just LIMIT returns fast; query with just ORDER BY returns […]
PostgreSQL Size Quota on Table or Schema
Question : How do one limit the size of a PostgreSQL table? (or schema) Limit in either bytes or rows […]
Why does adding LIMIT to my query make it crawl?
Question : Simple query: select sum(score) total,name,gender,dob,country from users join scores on users.id = scores.user_id where date between ‘2012-01-01’ and […]
Will MongoDB exceed the 64000 ulimit threshold?
Question : We are using MongoDB as a newbie and today we have exceeded the ulimit of the system causing […]
Why does adding LIMIT to my query make it crawl?
Question : Simple query: select sum(score) total,name,gender,dob,country from users join scores on users.id = scores.user_id where date between ‘2012-01-01’ and […]
data model limit rows per user
Question : This is regarding to postgres that I was asked to create data model which has a relationship with […]
In MySQL, what’s the most efficient way to query an entire table in chunks?
Question : If I have a table User is it faster to do something like: SELECT * FROM user WHERE […]
How to limit maximum number of rows in a table to just 1
Question : I have a configuration table in my SQL Server database and this table should only ever have one […]
Limiting the Number of Records Joined
Question : How can I perform a query that contains a (one-to-many) join between two tables, which will only join […]