You can specify runtime constraints on memory and CPU, but not disk space. The ability to set constraints on disk space has been requested (issue 12462, issue 3804), but isn’t yet implemented, as it depends on the underlying filesystem driver. This feature is going to be added at some point, but not right away. It’s … Read more
I thought it has been around a little longer, but according to this, MySQL 5.7.4 introduces the ability to set server side execution time limits, specified in milliseconds, for top level read-only SELECT statements. SELECT /*+ MAX_EXECUTION_TIME(1000) */ –in milliseconds * FROM table; Note that this only works for read-only SELECT statements. Update: This variable … Read more
This question is actually a very interesting one which mathematicians have devoted a fair bit of thought to. You can read about it in this article, which is a fascinating and accessible read. Briefly, a guy named Tibor Rado set out to find some really big, but still well-defined, numbers by defining a sequence called … Read more
Yes, it’s after the ORDER BY. For your query, you’d get the record with the highest publishedOn, since you’re ordering DESC, making the largest value first in the result set, of which you pick out the first one.
32bit or 64bit? 32bit is 2gb (for a process), 64 bit is 1TB (enterprise edition 2003 server). However, the maximum size of a CLR Object is 2gb even on 64bit. Update: the information above was correct in 2008. See Ohad’s answer for more recent information. Windows 2016 server can have a maximum of 24TB.
Quota is based upon filesystems, but you can always create a virtual filesystem and mount it on a specific (empty) directory with the usrquota and/or grpquota flags. In steps this will be: create the mount point create a file full of /dev/zero, large enough to the maximum size you want to reserve for the virtual … Read more
Although it still is answered, I want to share what I learned. myDataFrame.take(10) -> results in an Array of Rows. This is an action and performs collecting the data (like collect does). myDataFrame.limit(10) -> results in a new Dataframe. This is a transformation and does not perform collecting the data. I do not have an … Read more
When you have both the LIMIT and ORDER BY, the optimizer has decided it is faster to limp through the unfiltered records on foo by key descending until it gets five matches for the rest of the criteria. In the other cases, it simply runs the query as a nested loop and returns all the … Read more
By default, count() ignores limit() and counts the results in the entire query. So when you for example do this, var a = db.collection.find(…).limit(10); running a.count() will give you the total count of your query.
One thing you could do (this of course depends on what you are trying to accomplish) is: Store the necessary information (i.e. like a loop counter) in a spreadsheet or another permanent store(i.e. ScriptProperties). Have your script terminate every five minutes or so. Set up a time driven trigger to run the script every five … Read more