Getting Next Existing Record in a DB 

Wondered how to do it,, & did it Using offset:

sql:

SELECT * FROM foo WHERE id = 4 OFFSET 1


Comments

Post a Comment

Popular posts from this blog

How to increase Elasticsearch Shard recovery Speed

To Increase Shard recovery speed do this: Increase node recovery speed PUT http://es:9200/_cluster/settings { "persistent" : { "indices.recovery.max_bytes_per_sec": "200mb", "indices.recovery.max_concurrent_file_chunks": 5, "cluster.routing.allocation.node_concurrent_recoveries" : 5 } } Links: https://www.elastic.co/guide/en/elasticsearch/reference/current/shards-allocation.html https://www.elastic.co/guide/en/elasticsearch/reference/current/recovery.html
Read more

Install Cpanm module error : No such file or directory opening compressed index

I got this error while installing Rest client perl module $ HOME=/tmp /home/perl/5.10/bin/cpanm REST::Client ! Finding REST::Client on cpanmetadb failed. ! cannot open file '/tmp/.cpanm/sources/http%www.cpan.org/02packages.details.txt.gz': No such file or directory opening compressed index ! Couldn't find module or a distribution REST::Client Solution: The problem is because of "LWP::Protocol::https" module. Removing the directory worked for me. $ cd /perl_installed_path/perl/5.10/lib/site_perl/5.10.1 $ rm –rf LWP* or try with option "--no-lwp" cpanm REST::Client --no-lwp
Read more