Introduction A query is a request for information from a database. Initially when we have small amount of data everything runs well. Now It has been long time since your team have developed the application. The same query that you were executing earlier was working fine but now it is taking more time. Query optimizer attempts to determine the most efficient way to execute a given query. So in short “Query optimization” is the overall process of choosing the most efficient …
Month: August 2016
Setup Process of OpenVPN server with zentyal
What is OpenVPN Overview OpenVPN is open source software which means that everyone can freely use it and modify it as needed that implements virtual private network (VPN) techniques for creating secure point-to-point or site-to-site connections in routed or bridged configurations and remote access facilities. It uses a custom security protocol that utilizes SSL/TLS for key exchange. Zentyal Community Edition offers plenty of features to meet your needs, which includes OpenVPN also. 1. 0penVPN has the following advantages: …
Continue reading Setup Process of OpenVPN server with zentyal
Object Relational Mapping in PHP
This blog is about what is Object Relational Mapping? Why and when we should use Object Relational Mapping with PHP. What is Object Relational Mapping? Object-Relational Mapping in computer science is a programming technique for converting data between incompatible type systems in object-oriented programming languages. This creates, in effect, a “virtual object database” that can be used from within the programming language. It treats data stored in relational (SQL) database table records as if they are objects. It is like …