Kolmar Kafran
Kolmar Kafran
I agree.
Hey man, nice job, I will look at it. THanks =)
@joshuahlang I would like to use ctds on my ETL process, mainly because of the bulk feature. I'm relatively new to this area, I was working more with Data Analysis...
@HuangRicky Thank you. This Python 3 decode tip is a great one. Do you use Pandas for your ETL process? The tables I need to move are 200M~500M+ rows. I...
@joshuahlang You wrote a ctds' SQLAlchemy dialect. Can't SQLAlchemy handle ctds' VarChar and NVarChar transparently?
>``` > # to bulk_insert using the pandas generator. it's using less memory than using df.to_records. > tdsconnection.bulk_insert(table, df.itertuples(index=False, name=None)) > ``` @HuangRicky, since Pandas 0.24.0 there is a new...
> I doubt your approach might be slower than the in memory generator approach. you can test on some dataframe and compare the performance. I'm trying to implement it with...
Will this ever be possible?
Avoid varchar/nvarchar (max). Use ntext instead.
@joshuahlang Thanks. I think I better understand now.