Skip to main content
B
Bachi_Boy
Participant
November 16, 2009
Question

Call to stored proc dies in Internet Explorer 8

  • November 16, 2009
  • 1 reply
  • 375 views

Hi all,

I have a weird issue I was hoping the community here could help me with.

I am calling a stored proc on our AS400.  A table is dynamically created by the AS400.  The stored proc passes back the table name.  Then I query the newly created table and output the data to the browser.

The problem is,  it takes 15 seconds for this to execute in Firefox v3.5.5 and takes about 16 minutes to execute in Internet Explorer 8.

Does anyone have any insight as to what might be causing the data to hang? I can post my code if requested.

Thanks for any help in advance.

    This topic has been closed for replies.

    1 reply

    D
    Daverms
    Inspiring
    November 17, 2009

    Hi,

    Do you have any AJAX / DHTML stuff in your page?. (IE8 doesn't play well with those items normally...)

    What happens if you try the "Compatiablity mode" of IE8?.

    HTH

    B
    Bachi_BoyAuthor
    Participant
    November 17, 2009

    I don't have any AJAX or DHTML no.  However,  I did find a few hours after posting this that IE has to process the entire table before rendering in order to figure out row/column sizes. Firefox "renders and adjusts" the table as it parses the table.

    So it's a known issue in IE8 that we are expected to deal with .   When my form submits, it feeds parameters to the stored proc.  Then I query the table that the proc passes back to me to display the data in an HTML table.  When I remove the HTML and just blast data out to the screen, the browser finishes rendering within 4 seconds.

    So, my solution, is to display 500 records at a time thus eliminating the slow speed.  I wish IE supported progressive tables/HTML. I know it's cheesy to post a question and mark your own answer as the solution, but in case someone else runs into the same issue, I'm hoping this helps them.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices