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 2 years ago by sebTips0 comments – viewed 8,435 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,527 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 32,122 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 3 years ago by macinvilleTutorials1 comment – viewed 20,023 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-tos6 comments – viewed 27,058 times – ( +44 ) – version 1.1
Original source code and idea are from: PHP, PDO & Nested Transactions.