mxODBC Zope DA and Stored Procedures

• somnium7

  Old Hand

  Points: 347

  More actions

  January 24, 2007 at 2:09 pm

  #95034

  Maybe I should post this in a forum about Zope/Plone development. Problem with that is most of those guys/gals are using MySQL and not SQL Server. In case you're wondering here's the link to eGenix's mxODBC adapter -

  http://www.egenix.com/files/python/mxODBC-Zope-DA.html

  Now the issue is performance when using stored procedures. I had to set my DA for "Fetch last available result set" in order to use a proc that generates result subsets. Problem is the sluggishness of the result. I don't think the fault lies with the proc because running it in Query Analyzer shows acceptable performance. Is anybody else using this adapter with SQL Server and running SPs?

  My setup is:

  Zope\2.9.6 (no Plone)

  mxODBC

  SQL Server 2K

  Win XP Pro

  Any ideas on how to make it perform better?

  Thank you!!!

• January 29, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Bryan Simmons

  Newbie

  Points: 5

  More actions

  February 28, 2007 at 10:28 am

  #692363

  I am having the same problem with Zope and mxODBC.

  I'll let you know if I solve it.

• somnium7

  Old Hand

  Points: 347

  More actions

  March 1, 2007 at 7:07 am

  #692573

  If you can't solve it or you do solve it please post back here. I am interested in helping out or hearing from others using this combination.

  Also I found threads for one of the Zope mailing lists where people had related issues but subscription to the list seems broken. It mailed back my confirmation email but after confirming I couldn't send or recieve the list.

  I found this today:

  https://www.egenix.com/mailman/listinfo/egenix-users

  Maybe better luck here...