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 tr

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-

Newbie: Error parsing csv file with very long lines

2016-04-23 Thread salvari via Digitalmars-d-learn
Hello all! I'm trying to read a csv file (';' as separator) with very long lines. It seems to be really simple, I read the columns name with no problem. But as soon as the program parses the first line of data, the array containing the columns names seems to be overwrited. I'm using dmd:

Re: Newbie: Error parsing csv file with very long lines

2016-04-23 Thread salvari via Digitalmars-d-learn
Fixed!!! Thanks a lot. :-) But I have to think about this. I don't understand the failure.

Re: Newbie: Error parsing csv file with very long lines

2016-04-23 Thread salvari via Digitalmars-d-learn
On Saturday, 23 April 2016 at 11:18:08 UTC, rikki cattermole wrote: On 23/04/2016 10:57 PM, salvari wrote: Fixed!!! Thanks a lot. :-) But I have to think about this. I don't understand the failure. .dup duplicates memory. What this means is, it allocates a new block of memory and copies th

Re: Newbie: Error parsing csv file with very long lines

2016-04-23 Thread salvari via Digitalmars-d-learn
On Saturday, 23 April 2016 at 11:13:19 UTC, Nicholas Wilson wrote: On Saturday, 23 April 2016 at 10:57:04 UTC, salvari wrote: Fixed!!! Thanks a lot. :-) But I have to think about this. I don't understand the failure. stdin.byLine() reuses its buffer. so the old arrays in columns point to t