Re: mysql-native: SQL Transaction support?

2015-09-18 Thread salvari via Digitalmars-d-learn
On Thursday, 17 September 2015 at 21:19:07 UTC, Gary Willoughby wrote: On Thursday, 17 September 2015 at 19:47:33 UTC, salvari wrote: I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours to load data. I've used

mysql-native: SQL Transaction support?

2015-09-17 Thread salvari via Digitalmars-d-learn
I'm using mysql-native library for massive data load. I've been trying to use transactions to improve performance but it doesn't seem to work. I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours to load data. I've

Re: mysql-native: SQL Transaction support?

2015-09-17 Thread Gary Willoughby via Digitalmars-d-learn
On Thursday, 17 September 2015 at 19:47:33 UTC, salvari wrote: I'm parsing a text input file, the generated sql is about 1 million lines of SQL. By using mysql-native it takes about 4 hours to load data. I've used mysql-native before to handle hundreds of millions of rows of data and I