Stack Overflow
Stack Overflow

Questions tagged [limit]

Relates to any sort of limit applied to data or resources, e.g. limiting the size or value of a variable, limiting the rate of incoming traffic or CPU usage. [tag:sql-limit] should be used to refer to the LIMIT keyword in SQL.

Relates to any sort of limit applied to data or resources:

  • Limit a size of a database
  • Limit the admissable value of a variable
  • Limit to the rate of incoming traffic
  • Limit to CPU/reqource usage

Also relating to the mathematical notion of limit: the value that a sequence of numbers "approaches" as the sequence progresses.

Use for questions related to LIMIT keyword in SQL.

4370 questions
640
votes
22 answers

How many files can I put in a directory?

Does it matter how many files I keep in a single directory? If so, how many files in a directory is too many, and what are the impacts of having too many files? (This is on a Linux server.) Background: I have a photo album website, and every image…
Kip
  • 107,154
  • 87
  • 232
  • 265
476
votes
11 answers

Why does the 260 character path length limit exist in Windows?

I have come up against this problem a few times at inopportune moments: Trying to work on open source Java projects with deep paths Storing deep Fitnesse wiki trees in source control An error trying to use Bazaar to import my source control…
Jeffrey Cameron
  • 9,975
  • 10
  • 45
  • 77
474
votes
14 answers

How many levels of pointers can we have?

How many pointers (*) are allowed in a single variable? Let's consider the following example. int a = 10; int *p = &a; Similarly we can have int **q = &p; int ***r = &q; and so on. For example, int ****************zz;
Parag
  • 7,746
  • 9
  • 24
  • 29
265
votes
5 answers

Repository size limits for GitHub.com

Lately I have been using GitHub and I am wondering what is the repository size limit for files hosted on github.com?
user6510107
264
votes
6 answers

What is the email subject length limit?

How many characters are allowed to be in the subject line of Internet email? I had a scan of The RFC for email but could not see specifically how long it was allowed to be. I have a colleague that wants to programmatically validate for it. If there…
Scott Ferguson
  • 7,690
  • 7
  • 41
  • 64
253
votes
17 answers

Elasticsearch: Max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]

I have an issue with a systemd config for ElasticSearch. [Unit] Description=platform-elasticsearch After=syslog.target network.target remote-fs.target nss-lookup.target [Service] User={{ app_user }} Group={{ app_group…
casibbald
  • 2,805
  • 2
  • 16
  • 14
232
votes
4 answers

Run a query with a LIMIT/OFFSET and also get the total number of rows

For pagination purposes, I need a run a query with the LIMIT and OFFSET clauses. But I also need a count of the number of rows that would be returned by that query without the LIMIT and OFFSET clauses. I want to run: SELECT * FROM table WHERE /*…
Tim
  • 4,999
  • 3
  • 24
  • 29
225
votes
6 answers

Why does MYSQL higher LIMIT offset slow the query down?

Scenario in short: A table with more than 16 million records [2GB in size]. The higher LIMIT offset with SELECT, the slower the query becomes, when using ORDER BY *primary_key* So SELECT * FROM large ORDER BY `id` LIMIT 0, 30 takes far less…
Rahman
  • 2,253
  • 3
  • 14
  • 6
221
votes
10 answers

How to limit the maximum value of a numeric field in a Django model?

Django has various numeric fields available for use in models, e.g. DecimalField and PositiveIntegerField. Although the former can be restricted to the number of decimal places stored and the overall number of characters stored, is there any way to…
user82216
213
votes
18 answers

Equivalent of LIMIT and OFFSET for SQL Server?

In PostgreSQL there is the Limit and Offset keywords which will allow very easy pagination of result sets. What is the equivalent syntax for SQL Server?
Earlz
  • 62,085
  • 98
  • 303
  • 499
209
votes
8 answers

Maximum number of records in a MySQL database table

What is the upper limit of records for MySQL database table. I'm wondering about autoincrement field. What would happen if I add milions of records? How to handle this kind of situations? Thx!
xpepermint
  • 35,055
  • 30
  • 109
  • 163
182
votes
7 answers

Can HTTP POST be limitless?

What is the specification for maximum data size one can send with HTTP POST method?
IAdapter
  • 62,595
  • 73
  • 179
  • 242
181
votes
7 answers

How can I list (ls) the 5 last modified files in a directory?

I know ls -t will list all files by modified time. But how can I limit these results to only the last n files?
Ryan
  • 14,682
  • 32
  • 106
  • 179
176
votes
16 answers

LIMIT 10..20 in SQL Server

I'm trying to do something like : SELECT * FROM table LIMIT 10,20 or SELECT * FROM table LIMIT 10 OFFSET 10 but using SQL Server The only solution I found looks like overkill: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row…
marcgg
  • 65,020
  • 52
  • 178
  • 231
165
votes
12 answers

What is a reasonable length limit on person "Name" fields?

I have a simple webform that will allow unauthenticated users to input their information, including name. I gave the name field a limit of 50 characters to coincide with my database table where the field is varchar(50), but then I started to…
EndangeredMassa
  • 17,208
  • 8
  • 55
  • 79
1
2 3
…
99 100