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
44
votes
2 answers

How to set limit on directory size in Linux?

I have read about limiting size of directory - like creating big files, formatting,mount,.. etc. But this all very complicated. Does exist utility or something else to set limit on already existing directory?
user710818
  • 23,228
  • 58
  • 149
  • 207
44
votes
5 answers

spark access first n rows - take vs limit

I want to access the first 100 rows of a spark data frame and write the result back to a CSV file. Why is take(100) basically instant, whereas df.limit(100) .repartition(1) .write .mode(SaveMode.Overwrite) .option("header",…
Georg Heiler
  • 16,916
  • 36
  • 162
  • 292
43
votes
3 answers

Is MySQL LIMIT applied before or after ORDER BY?

Which one comes first when MySQL processes the query? An example: SELECT pageRegions FROM pageRegions WHERE(pageID=?) AND(published=true) AND (publishedOn<=?) ORDER BY publishedON DESC LIMIT 1'; Will that return the last published pageRegion even…
Chris Abrams
  • 39,732
  • 19
  • 51
  • 57
43
votes
6 answers

Is there a memory limit for a single .NET process

We are currently thinking of building a cache-system to hold data pulled out of an SQL database and make it available to a couple of other applications (website, webservice, etc). We imagine the cache to be running as a windows service and basically…
Mats
  • 14,902
  • 33
  • 78
  • 110
42
votes
6 answers

How to set a maximum execution time for a mysql query?

I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can I do ?
microry
40
votes
16 answers

What's the biggest number in a computer?

Just asked by my 5 year old kid: what is the biggest number in the computer? We are not talking about max number for a specific data types, but the biggest number that a computer can represent. Infinity is not allowed. UPDATE my kid always wants to…
Yehonatan
  • 1,172
  • 2
  • 11
  • 21
38
votes
1 answer

How to limit Docker filesystem space available to container(s)

The general scenario is that we have a cluster of servers and we want to set up virtual clusters on top of that using Docker. For that we have created Dockerfiles for different services (Hadoop, Spark etc.). Regarding the Hadoop HDFS service…
Björn Jacobs
  • 4,033
  • 4
  • 28
  • 47
37
votes
3 answers

What is max length for an C/C++ identifier on common (build) systems?

I don't remember the standard saying something of the max length for identifiers so in theory they can be long. In real life, those names could be limited by at least the compiler and linker implementations. While this should work on all systems int…
mbx
  • 6,292
  • 6
  • 58
  • 91
36
votes
2 answers

Cassandra has a limit of 2 billion cells per partition, but what's a partition?

In Cassandra Wiki, it is said that there is a limit of 2 billion cells (rows x columns) per partition. But it is unclear to me what is a partition? Do we have one partition per node per column family, which would mean that the max size of a column…
Benoit Thiery
  • 6,325
  • 4
  • 22
  • 28
35
votes
2 answers

How much memory of Memcache is available to a Google App Engine account?

Google App Engine has some information about Memcache limits: http://code.google.com/appengine/docs/quotas.html#Memcache http://code.google.com/appengine/docs/python/memcache/overview.html#Quotas_and_Limits However, total allowed size of…
Viet
  • 17,944
  • 33
  • 103
  • 135
35
votes
4 answers

Google drive limit number of download

I have obtain the download url via webContentLink (https://docs.google.com/a/onwardsct.com/uc?id=0ByvXJAlpPqQPYWNqY0V3MGs0Ujg&export=download) During testing, I try to download 28 times (testing) the same 24mb file using 3 different Google accounts…
simon
  • 371
  • 1
  • 3
  • 5
35
votes
3 answers

How do I limit the amount of results returned in Sybase?

I need to query a Sybase database which has a lot of data in it, and would like to set a limit so the DB stops the query after 10 results. The key thing is performance, so it would be no use if it searched all results and then then returned the last…
Ryan
  • 353
  • 1
  • 3
  • 4
35
votes
8 answers

Maximum size of object that can be saved in memcached

I need to return a rather big file (11MB) to the user. For certain reasons, I can't just provide a direct url to the file (http://www.sample.com/mybigfile.exe); instead it must be accessed through code. Instead of having to read it from disk over…
cfischer
  • 24,452
  • 37
  • 131
  • 214
34
votes
1 answer

Mysql delete statement with limit

I'm trying to delete rows from a table but I get an error. DELETE FROM `chat_messages` ORDER BY `timestamp` DESC LIMIT 20, 50; I get this error at 50: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server…
SBSTP
  • 3,479
  • 6
  • 30
  • 41
34
votes
4 answers

Force fact-gathering on all hosts

I'm sitting in front of a fairly complex Ansible project that we're using to set up our local development environments (multiple VMs) and there's one role that uses the facts gathered by Ansible to set up the /etc/hosts file on every VM.…
tehK
  • 2,265
  • 4
  • 17
  • 16
1 2 3
…
99 100