Monthly Archives: June 2017

SQL Optimization Techniques

Optimize access structures: Database design and normalization. Tables: heap or index-organized tables, and table or indexed clusters. Indexes. Constraints. Materialized views. Partitioning schemes. Statistics, including a comprehensive refresh strategy. Rewrite SQL statements: Exclude projections that are not required. Minimize the … Continue reading

Posted in MysQl | Tagged , , , | Leave a comment

How to identify user idle state by minutes using javascript / JQuery?

Descrption: i used with 20 minute of interval if user is in idle state from last 20 minute then it will call the timerIncrement() and then will check for 20 minutes if yes or not. Why i need this? i … Continue reading

Posted in angular-4, Javascript, jQuery | Tagged , , , , | Leave a comment

what is difference between oracle & mysql ?

Key difference: The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number … Continue reading

Posted in database, MysQl, oracle | Tagged , , , | Leave a comment

Rest api cakephp -3 pagination

For web we are using Paginate component & for view we used the paginator helper, what is the standard way to enable pagination i am using following technology. Cakephp-3 php MVC framework as Back-end Tech Angular-js 4 as fronted Cakephp … Continue reading

Posted in API, cakephp-3 | Tagged , | Leave a comment

How do I install Sublime Text 2/3?

Install via the Package Manager(apt-get): Simply add to your packages: For Sublime-Text-2: sudo add-apt-repository ppa:webupd8team/sublime-text-2 sudo apt-get update sudo apt-get install sublime-text For Sublime-Text-3: sudo add-apt-repository ppa:webupd8team/sublime-text-3 sudo apt-get update sudo apt-get install sublime-text-installer Run Sublime-Text on terminal subl

Posted in Ubuntu | Leave a comment