Hi Betty, You say 'the script stops at 36'. That sounds to me as if you are creating all 186 spreadsheets in one request. Is it possible to generate them one by one? That might also allow parallel processing them.
You also say that a larger case deals with a spreadsheet of 664k+ rows and takes an hour. You will have to tell more about the strategy you use in order to help with optimizations. I have one thought though: could taking multiple steps be a solution? Colleen asks whether you are running this in the background or not. App and Task server both have their own timeout setting. Background processing makes employing CPF interesting too. Kind regards, Geert > -----Oorspronkelijk bericht----- > Van: [email protected] [mailto:general- > [email protected]] Namens Betty Harvey > Verzonden: woensdag 15 februari 2012 0:04 > Aan: MarkLogic Developer Discussion > Onderwerp: [MarkLogic Dev General] How to Stop Time Out > > Is there anyway to tell MarkLogic not to time out. I have developed a > query that is cycles through the database and creates an Excel spreadsheet > for each distinct group of values. > > There are 2.4 million documents in the database. There should be a total > of 186 spreadsheets that get created. The script stops at 36 > spreadsheets. I tested one of the larger values that resulted in a total > of 664,000+ rows in the Excel spreadsheet and it took approximately an > hour. > > I need someway of telling MarkLogic not to time out on this query. I > really don't want to increase the time for timeout. I am working in a > test environment and this option isn't an available option in production. > > TIA! > > Betty > > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/ > Betty Harvey | Phone: 410-787-9200 FAX: 9830 > Electronic Commerce Connection, Inc. | > [email protected] | Washington,DC XML Users Grp > URL: http://www.eccnet.com | http://www.eccnet.com/xmlug > /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\/\/ > Member of XML Guild (www.xmlguild.org) > _______________________________________________ > General mailing list > [email protected] > http://developer.marklogic.com/mailman/listinfo/general _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
