CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363

CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363

CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363
PHP Script \ Database Abstractions
Mysql \ Memcache \ Mysqli \ Json \ Filecache \ Class \ Cache \ Disk \ Fast \ Array


PHP Script - cQL Best SQL pdo mysqli mysql Cache Class 10102363 by soyturk @ CodeCanyon

PHP Script \ Database Abstractions

Last Update: 27 January 15; High Resolution: Yes; Files Included: PHP; Software Version: PHP 5.x, MySQL 4.x, MySQL 5.x.

cQL
This is a php coding that enables you to receive higher volume of data with your mysql inquires. You’ll be enable to decrease the load on your users.

How it is working?
When you use this coding in the inquiry field it will record the data as json format to the database in the first place. This record will be saved on memcache for a specific time set by you. If you do same inquiry during that specific time again the recorded data will be read and shown to user directly instead of getting data from database.

Sample explanation
For instance let’s assume that you have a video sharing site and getting data from database and shown to users. You’ll compulsorily do the same action again and again for each user and repeated mysql connection occurs. Instead of following this process again and again you can use this coding to keep your server less busy and get success easier.

Benchmarking Query
MySQL .
$query = mysql_query("SELECT * FROM table LIMIT 100");
$data = http://codecanyon.net/item/cql-best-sql-pdo-mysqli-mysql-cache-class/mysql_fetch_assoc($query);
// 1.2934579849243 sec with use only MySQL
MySQLi
$query = mysqli_query($con,"SELECT * FROM table LIMIT 100");
$data = http://codecanyon.net/item/cql-best-sql-pdo-mysqli-mysql-cache-class/mysqli_fetch_assoc($query);
// 1.2859179973602 sec with use only MySQLi
$data = http://codecanyon.net/item/cql-best-sql-pdo-mysqli-mysql-cache-class/$cql->get("SELECT * FROM table LIMIT 100");
// 0.00059390068054199 sec with use cQL

Requirements

- PHP 5.x

- memcahe extension

- MySQL

Updated v.1.1

added pdo and mysqli queries on new class file.
include 'class.cache.php';
$cql = new cql;
use pdo : $cql->using("pdo");
use mysqli : $cql->using("mysqli");
use mysql : $cql->using("mysql");
or change class file .
public $using = "mysql"; // mysql - mysqli - pdo

Stick Hero; Vine Api Class;

Keywords: array, cache, class, cql, disk, fast, filecache, json, memcache, mysql, mysqli, pdo, php, xml.



Tags: Cache, Class, Mysqli, Mysql, Filecache, Memcache, Array

Premium CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363 WordPress Themes, Website Templates, Mobile Themes, Flash Templates & Scripts from creative professional designers. Full details of CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363 for digital design and education. CodeCanyon cQL Best SQL pdo mysqli mysql Cache Class 10102363 desigen style information or anything related.

Comments:

Name:*
E-Mail:*
Add Comments:
Enter Code: *