778 reputation
11839
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 3 years
seen Aug 24 at 14:04

intentionally left blank


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.
Aug
26
asked in-memory SQL database system
Aug
23
awarded  Popular Question
Aug
15
accepted How to get MAX and MIN in GROUP BY query?
Aug
15
asked How to get MAX and MIN in GROUP BY query?
Jul
22
awarded  Notable Question
Jun
25
awarded  Popular Question
Jun
20
awarded  Popular Question
Jun
5
awarded  Popular Question
Jun
4
comment How to run a SELECT query within while loop in PHP?
as I said, the problem is that there not two tables only. Table 1 is the main table in the query, the second query can be from table2, table3, table4, table5, table6, .... The problem is that PHP arrays are not very efficient for data processing to catch a large set of data into arrays.