Re: Crystal with Informix 7.3 Problems?

Try setting up a second database, using views and synonyms to the live database. This is the way we get around the a similar problem. Hans Siebrand Data Analyst / Senior DBA Iluka Resources Limited PH: +61 8 9780 3610 Fax: +61 8 9780 3686 Mob: +61 409 116 533 Email: hans.siebrand@iluka.com Calvin Shoults wrote in message <8klqch$l1i$1@nntp9.atl.mindspring.net>... >We run 5 to 20 large crystal reports at any one time. The more crystal >reports that are running the higher the load on the system. >They are locking up every table they hit. >Has anyone found a solution to this problem other than scrapping crystal? >What about stored procedures? > > >

Hi! Is there any way you could use dirty read - is there anything in Crystal reports that would allow you to select isolation mode. Also check for some posts regarding similar problem a few weeks ago. If you can use stored procedure (I do with Infomaker), you can control the isolation mode, but also optimize selects and joins. Might be worth the try. HTH Michael Hans Siebrand wrote: > Try setting up a second database, using views and synonyms to the live > database. > > This is the way we get around the a similar problem. > > Hans Siebrand > Data Analyst / Senior DBA > Iluka Resources Limited > > PH: +61 8 9780 3610 > Fax: +61 8 9780 3686 > Mob: +61 409 116 533 > Email: hans.siebrand@iluka.com > > Calvin Shoults wrote in message <8klqch$l1i$1@nntp9.atl.mindspring.net>... > >We run 5 to 20 large crystal reports at any one time. The more crystal > >reports that are running the higher the load on the system. > >They are locking up every table they hit. > >Has anyone found a solution to this problem other than scrapping crystal? > >What about stored procedures? > > > > > >