Mike,
Er, yeah, not TSQL, my old MSSQL days are showing :D meant a str() of sql
I'm saying bindparms as the required input format of the params used to
re-bind into the sql in the optimal way, for example
execute(__table__.insert(), bindparams) would represent a list of dicts.
I did a packet
On Thu, Oct 4, 2018 at 4:04 PM wrote:
>
> Mike,
>
> No, I'm not calling execute 10k times, but I am doing what they do in your
> example with test_core_insert
>
> My code for that is:
> log.info('Executing sqlalchemy insert() with bindparams as
> execute param -
Mike,
No, I'm not calling execute 10k times, but I am doing what they do in your
example with test_core_insert
My code for that is:
log.info('Executing sqlalchemy insert() with bindparams as
execute param - session.execute(__table__.insert(), bindparams)')
On Thu, Oct 4, 2018 at 2:45 PM wrote:
>
> Hi all,
>
> Having some very and major performance issues using sqlalchemy to insert
> data, been trying many different ways but none seem to hold even a close
> candle to raw MySQLdb connections
>
> Versions:
> sqlalchemy: 1.2.9
> MySQLdb: 1.3.13
Hi all,
Having some very and major performance issues using sqlalchemy to insert
data, been trying many different ways but none seem to hold even a close
candle to raw MySQLdb connections
Versions:
sqlalchemy: 1.2.9
MySQLdb: 1.3.13 (bound with mysql+mysqldb connector)
MySQL: 14.14
Python:
On Thu, Oct 4, 2018 at 5:10 AM wrote:
>
> That's great ! Thanks a lot !
>
> Btw it seems that the
>
> self.inline = getattr(stmt, 'inline', None)
>
> is no longer necessary, I tryed my insert exemple with it commented and it
> still runned fine.
well there's also an "inline" argument for
a PR would at least remind me to look into it even if i dont use your
suggested verbiage as is, thanks!
On Thu, Oct 4, 2018 at 4:07 AM wrote:
>
> To follow this up - what would be the best way to get these extra dragons in?
> I would be happy to submit a PR or something if that is easier.
>
> On
That's great ! Thanks a lot !
Btw it seems that the
self.inline = getattr(stmt, 'inline', None)
is no longer necessary, I tryed my insert exemple with it commented and it
still runned fine.
Le jeudi 4 octobre 2018 05:23:02 UTC+2, Mike Bayer a écrit :
>
> The insert is by itself not a
To follow this up - what would be the best way to get these extra dragons
in? I would be happy to submit a PR or something if that is easier.
On Friday, September 14, 2018 at 10:32:52 AM UTC+2, ja...@cryptosense.com
wrote:
>
> Thanks for the help - I had missed the "copy vs modifying in place"