[sqlalchemy] slow autoload with SqlServer Information Schema

2007-06-22 Thread d_henderson
The query to autoload foreign keys from the information schema views on MS SQL Server performs very poorly for large databases. I extracted the query from the log generate with metadata.engine.echo = True. I tested used both windows and cygwin versions of python 2.5, pyodbc 2.0.36, SQLAlchemy

[sqlalchemy] sqlalchemy.engine.engine_descriptors() is broken

2007-06-22 Thread d_henderson
A call to sqlalchemy.engine.engine_descriptors() fails with this traceback: $ ./python test_sa1.py engine_descriptors(): Traceback (most recent call last): File test_sa1.py, line 62, in module print 'engine_descriptors():',sqlalchemy.engine.engine_descriptors() File

[sqlalchemy] Re: help with IronPython

2007-06-21 Thread d_henderson
On Jun 20, 2:09 pm, Rick Morrison [EMAIL PROTECTED] wrote: The SA MSSQL module currently supports the three DBAPI modules mentioned above (pyodbc, pymssql, adodbapi). You'll need to either get one of those three to import under IronPython, or add support for the IPCE adaptor. pyodbc,

[sqlalchemy] help with IronPython

2007-06-20 Thread d_henderson
I recently tried SA again, and found that IronPython can now import it without errors. I seem to be missing some critical bit when connecting the driver to SA I have IPCE-r6 ipy -V IronPython 1.1 (1.1) on .NET 2.0.50727.42 My test program starts like so: import sys, os, os.path import