howdy reddots We've got some pages that call an external database for some content - we're using MySQL ODBC (3.51). Everything seems to work fine in SmartEdit and preview. However when we try to publish, we are getting lots of out of memory errors from ODBC and our query log is showing what seems to be queries coming in from the publishing server with no WHERE clause at all. The 300,000+ rows of content would most likely cause an OOM error but why would the publishing process strip off the where clause? Its also making our publishing process run really slowly as it seems to try this query over and over again waiting as its memory runs out.
We have set ODBC to not cache forward cursors and also force it to always use a forward cursor - which we thought would tell ODBC to not try to cache the whole table. Has anyone else come across a problem like this? Any advice on getting ODBC to behave? Should we just skip the whole headache and use active template code to fetch our data? Is ODBC MySQL even reliable enough for production systems? our publishing report has row after row like this: ------------------------------- Procedure StopPageBuilder of Class Module RDPublisher: Error in line 50,-2147164145 (Method '~' of object '~' failed) ------------------------------- RequestPageFromPageBuilder: Page 20160, Pagebuilder send: PrepareTemplateVariantElements: ERROR#7, Out of memory, Line 0 ------------------------------- Procedure StopPageBuilder of Class Module RDPublisher: Error in line 50,-2147164145 (Method '~' of object '~' failed) ------------------------------- RequestPageFromPageBuilder: Page 20168, Pagebuilder send: PrepareTemplateVariantElements: ERROR#7, Out of memory, Line 0 Thanks for any guidance around this. Fej --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/RedDot-CMS-Users?hl=en -~----------~----~----~----~------~----~------~--~---
