From: Monteith A. <And...@bo...> - 2004-11-24 16:30:49
|
Hi Michael A little more info. If I toggle the view to include the result grid before pressing F9, it happens on the first press of the F9. If the result grid is hidden it only happens on the second pressing of F9. If I maximize the window ( lines 1-51 are visible, 1280x1024 ) it still does it. It does seem to be related to the number of lines, 93 lines does it, 89 lines is fine. I removed the if statements and added declare variable statements it still does it when 91 Lines is reached. No flicker at all. Hope this helps. Cheers Andrew Atlas Converting Equipment ltd Andrew Monteith Internal Software Development Engineer Phone +44 (0)1234 852553 Fax +44 (0)1234 851151 mailto: And...@bo... http://www.bobstgroup.com -----Original Message----- From: fla...@li... [mailto:fla...@li...] On Behalf Of Michael Hieke Sent: 24 November 2004 15:57 To: fla...@li... Subject: Re: [Flamerobin-devel] Using Run query results in 99% CPU usage. Hi Andrew, > everything is fine, but if I add to the query or change the query to > this... [snip] > . so that the Stored Procedure is about 90 odd lines long [snip] > FR starts using 99% of the CPU. This stops when I Close the Run > Query Form. is the number of lines important, or does this maybe depend on frame size (happens with fewer lines if the frame is smaller)? Has changing the view (hiding and showing the result grid or the sql editor control, or even the statusbar) any effect on the processor load? Is this something that might be caused by constant repainting of one or several of the controls - do you see any excessive flicker? Just trying to get an idea how to reproduce this... Thanks -- Michael Hieke ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Flamerobin-devel mailing list Fla...@li... https://lists.sourceforge.net/lists/listinfo/flamerobin-devel ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. adm...@bo... ********************************************************************** |