Re: Query Performance Question

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 3 Mar 2005 03:36:20 -0800
Message-ID: <1109849780.934154.55520@g14g2000cwa.googlegroups.com>

Daniel,

I looked into your suggestion and couldn't find any discrepencies with the data between the "machine processes" that work and the one's that don't.

I looked a little deeper into which "machine processes work and which don't. I have 285 different "machine processes".

I did a random test and it seems that "machine processes" with record counts larger than 5,120 don't work. Here's a condensed list of "machine processes" that work and don't work.

  Process #        |     Record Count
    3430                        1,130               Works
    3530                        2,492               Works
    3300                        3,950               Works
    4100                        4,593               Works
    36130                      5,120               Works
    5600                        6,052               Doesn't Work
    5100                        6,252               Doesn't Work
    3500                        6,897               Doesn't Work
    8550                      16,302               Doesn't Work
    8660                      35,266               Doesn't Work

There seems to be some sort of limit that is being reached that I cannot do my query with record counts larger than 5,120. I don't think that it's a problem with my data because all my data is being pulled from the same table.

I think there might be something wrong with either the way my instance is configured or with the way my SQL statement is written or both. Received on Thu Mar 03 2005 - 05:36:20 CST