hello, under the cms directory, there should be a RDServer.ini file
append the following setting xmlserver=0 this tells cms to run reach publication job as its own process. The drawback is that 20% longer publishing time. On Jul 22, 9:20 pm, Fej Reblok <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
