863 reputation
52241
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 3 years, 5 months
seen Aug 24 '14 at 14:04

intentionally left blank


Sep
17
asked How to get missing values in row order?
Sep
16
comment Do regular ALTERs weaken the performance?
@MaxVernon I know that it sounds crazy, but it is a live project in which the database structure is about to modified. Unfortunately, due to the rush, we could now extend the test period.
Sep
16
asked Do regular ALTERs weaken the performance?
Sep
15
accepted JOIN to read first table and get possible relationship in the second table
Sep
15
accepted Is it possible to force drop of mysql tables with FK?
Sep
15
accepted HOW to “SUM” and “JOIN” for single query of a poll results?
Sep
15
accepted How to run a SELECT query within while loop in PHP?
Sep
15
accepted Does a TRIGGER improve the performance?
Sep
15
accepted How to use OR in query with priority?
Sep
15
asked How to update a table by count from another table?
Sep
6
asked How to use OR in query with priority?
Aug
28
accepted Enabling LOAD DATA LOCAL INFILE in mysql
Aug
28
revised Does a TRIGGER improve the performance?
added 66 characters in body
Aug
28
comment Does a TRIGGER improve the performance?
@RaymondNijland innoDB
Aug
27
asked Does a TRIGGER improve the performance?
Aug
27
comment Enabling LOAD DATA LOCAL INFILE in mysql
Thanks for your practical instruction for debugging, what I really needed. In the first step, it revealed, I am on wrong track, as showed local_infile | ON . It seems the problem is not mysql, but PHP or probably the mysql-PHP connector/driver (mysqli).
Aug
26
revised Enabling LOAD DATA LOCAL INFILE in mysql
deleted 167 characters in body; edited title
Aug
26
asked Enabling LOAD DATA LOCAL INFILE in mysql
Aug
26
accepted in-memory SQL database system
Aug
26
comment in-memory SQL database system
SQLite is lightweight, but it does not have the mysql server, and in my experience there is no performance advantage over mysql.