Wiki

Articles tagged with "mysql"X
Displaying 1-5 of 5 result(s).

Speedup unit tests by moving MySql data to memory (in Ubuntu)

Created about a year ago by sebTips0 comments – viewed 7,702 times – ( +1 / -1 ) – version 1.1
Speedup unit tests by moving MySql data to memory [Ubuntu]
tags: mysql, unit test

mysql performance tip

Created 2 years ago by sirin kTips6 comments – viewed 7,185 times – ( +2 / -1 ) – version 1.1
When we are doing an insert of huge no.of rows into an SQL table ,Normally we will try to write separate insert quries this may lead us to a long duration of execution time and we can increase the speed of executing SQL quries by adding all the rows into a single insert query.
tags: mysql

Importing CSV file to mysql table using "LOAD DATA" command.

Created 2 years ago by sirin kTips12 comments – viewed 29,951 times – ( +7 ) – version 1.1
hi, Here i am giving you some simple step to import huge data from a csv file to your mysql table.this is useful when you have a very huge data to import from csv format.
tags: csv, mysql, import

Windows Web Development With AMPPS, NetBeans and XDebug

Created 2 years ago by macinvilleTutorials1 comment – viewed 19,288 times – ( +4 ) – version 1.1
This article will discuss how to setup your web development environment with the following specifications:

How to use nested DB transactions (MySQL 5+, PostgreSQL)

Created 5 years ago by mindehHow-tos5 comments – viewed 24,563 times – ( +42 ) – version 1.1
Original source code and idea are from: PHP, PDO & Nested Transactions.