Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.
This tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts. You will have accomplished after successfully completing this guide: setup the MySQL database server, setup the Apache web server, setup the PHP 3.0 Hypertext Preprocessor for server-side-scripting, and create a simple web enabled database.
The usage of databases in larger web-based applications is essential. By using basic object-orientated techniques we can minimize the fuss of connecting and interacting with a database. We can also reuse this code in other applications: a huge benefit of 'OO' programming.
A continuation of the series, "Data Integrity Using MySQL and PHP," this article discusses the concept of auto_increment fields in MySQL, to cause MySQL to store a unique, incrementing integer in the field of each new row.
As your website grows you may run into two problems: Your website has so much information that visitors can't quickly find what they want and visitors want to give you information. Both of these problems can be solved by building a database on a website. This introductory article shows you how to do this using basic PHP-MySQL interaction.
This is a detailed tutorial intended for the PHP programmer interested in learning more about database connectivity - using the ODBC standard. You should be familiar with PHP syntax and have a working knowledge of databases.
Got a MySQL database with content within it? Want to be able to search it and display paged search results on screen? This tutorial and script will do just that. (Apache, PHP, MySQL database required)
OO approach described in this article helps to create data layer abstractions which are easy to port to other databases without altering the application code
When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection. This article shows how to create functions that will eliminate this redundancy. The tutorial uses MySQL as the database, but the database layer is irrelevant. These functions can be adapted to use other databases.
0.0