[sqlalchemy] Re: PROBLEMS WITH TIMESTAMP variable in MySql

[robertz23]

Sorry for the delay.  Thanks for helping me.  It was a driver
problem.  I've solved this problem.
Thanks everybody for the help.

regards,
Roberto Zapata

On Jul 13, 3:57 pm, Michael Bayer [EMAIL PROTECTED] wrote:
 On Jul 13, 2007, at 3:41 PM, robertz23 wrote:



Thanks for the answers. I've tried what Christoph told, but returns
  the same error.  What I'm trying now is to override that column to be
  a DateTime type because in this case SQLAlchemy doesn't give me any
  errors, so I think you are right Michael, is because of the driver.
  Can tell me how to override this column so that SQLAlchemy can see it
  as a datetime. I have tried this, I do not know if this is correct or
  not:

  email_table = Table('email', metadata, Column('last_modified',
  DateTime()), autoload=True)

 that is correct although the mysql reflection should detect that type  
 from the TIMESTAMP column type regardless.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---

[sqlalchemy] Re: Insert through ORM performance (was: Performance question)

[Jonathan Ellis]

On 7/19/07, Mike Orr [EMAIL PROTECTED] wrote:
 I'm amazed at the speed of mysqldump and its reloading.  It packs a
 bunch of rows into one INSERT statement.  I don't see why that's so
 much faster than than executemany but it provides another potential
 avenue for speed.  I'm not sure if MySQL is the only engine that does
 this.

Here's an exhaustive set of timings on the options you have with
postgresql: 
http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/

summary: COPY is fastest; that is what pg_dump uses.  multi-row
inserts in transactions got within a factor of 3.  naive single-row
inserts were 30x slower than COPY.

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---