Published News » Database
This is a short tutorial on how to quickly get NGINX Web Server, PHP and PHP Driver for CUBRID Database installed on Linux systems.
Read More
Using Vala to update our Magento SQLite3 database
Read More
Why would you want to use SQLite3 with Magento? Just for fun… well actually there is a good reason. The reason is that Magento spends a lot of time in the autoload finding files. DO this in your terminal: strace -c php index.php
Read More
Welcome to the third and final part of the series in which we look at five alternative databases you can use with PHP apps you might not have heard of.
Read More
this article is to cover the concept to store the image in mysql database
Read More
MySQL events were added in MySQL 5.1.6 and offer an alternative to scheduled tasks and cron jobs. Events can be used to create backups, delete stale records, aggregate data for reports, and so on. Unlike standard triggers which execute given a certain condition, an event is an object that is triggered by the passage of time and is sometimes referred to as a temporal trigger. You can schedule even
Read More
The index-only scan belongs to the most powerful tuning methods at all. It utilizes not only the clustering of rows with similar values, but also exploits the fact that the index has a copy of the indexed data.
Read More
Version control for source code is used by most development teams today. It gives you a history of all the changes you made, you can use it to share your code with others and you can work on an experimental feature without polluting the stable product. These are just some of the reasons why version control software is considered indispensable today. But where does our database fit in all this? Ho
Read More
The complete CUBRID vs. MySQL PHP API functions comparison. There are 77 functions in CUBRID PHP API, 40 match w/ MySQL, 6 partially match, 31 unique to CUBRID, lack 12 MySQL specific.
Read More
Are you in control of your database or is it driving you mad? This list of 10 common MySQL mistakes may help when developing PHP applications.
Read More
How to improve the performance of our web applications running database queries asynchronously within PHP
Read More
The default configuration file for MySQL is intended not to use many resources, because its a general purpose sort of a configuration file. The default configuration does enough to have MySQL running happily with limited resources and catering to simple queries and small data-sets. The configuration file would most definitely need to be customized if you intend on using complex queries and when y
Read More
If you are in a situation where you have to insert a very large number of records into one table (with indexes on it) it may very well have occurred to you that such inserts take forever. To descrease the time usage we suggest 2 methods: A temp table or a table rename flow.
Read More
Search box most important element on web pages specially contented management sites. In this post I want to explain very basic searching techniques and Unicode data searching using SQL LIKE statement. I hope you like this. Thanks
Read More
A new version (9.0) of PostgreSQL is in beta and ready for public testing. If version 9.0 lives up to its proposed feature list, then it is serious competition for MySQL. PostgreSQL proponents have long suggested that PostgreSQL has always enjoyed superiority over MySQL. I beg to differ but that may be changing.
Read More
If you're having problems with server load due to high volume of traffic you can try getting fast cheap web hosting for your sites. Although web hosting is part of the solution you also need to consider other bandwidth heavy website applications.
