It’s because of UTF-16. Characters outside of the base multilingual plane (BMP) are represented using a surrogate pair in UTF-16 with the first code unit (CU) lies between 0xD800–0xDBFF and the second one between 0xDC00–0xDFFF. Each of the CU represents 10 bits of the code point, allowing total 20 bits of data (0x100000 characters) which … Read more
Another option is to use the prlimit command (from the util-linux package). For example if you want to set the maximum number of open files for a running process to 4096: prlimit -n4096 -p pid_of_process
Order by id DESC Limit 1: db.query(“table”, null, “column=?”, new String[]{“value”}, null, null, “id DESC”, “1”);
SELECT col FROM table LIMIT 0,5; — First page, rows 1-5 SELECT col FROM table LIMIT 5,5; — Second page, rows 6-10 SELECT col FROM table LIMIT 10,5; — Third page, rows 11-15 Read the LIMIT section on the MySQL SELECT helppage. If you want to display the total number of rows available, you can … Read more
Check out the thread on the JIRA ticket that increased the value from 4MB to 16MB. There is a sizeable debate on the ticket: https://jira.mongodb.org/browse/SERVER-431 It seems to be arbitrary why they chose 16MB, and not say 32MB. It was increased because many people needed to store documents larger than 4MB (and I presume lower … Read more
Paginate was merged with doctrine 2.2 And the new symfony2 release 2.0.10 is compatible with. Now use it like that //use Doctrine paginator use Doctrine\ORM\Tools\Pagination\Paginator; Write your query then call results like that. $query->setMaxResults($limit); $query->setFirstResult($offset); $results = new Paginator($query, $fetchJoin = true); Hope this will help you. Note: If you are using SF2 2.0.10, you … Read more
With the advent of CQL3 the terminology has changed slightly from the old thrift terms. Basically Create Table foo (a int , b int, c int, d int, PRIMARY KEY ((a,b),c)) Will make a CQL3 table. The information in a and b is used to make the partition key, this describes which node the information … 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.
Count the entries in /proc/<pid>/fd/. The hard and soft limits applying to the process can be found in /proc/<pid>/limits.
simply use DELETE FROM test WHERE 1= 1 LIMIT 10