Want to get rid of Google Ads, click here.
+ Reply to Thread
Results 1 to 3 of 3

Thread: SC 5.0.1 slow response on probsummary queries

  1. #1
    Junior Member
    Join Date
    Apr 2008
    Posts
    22

    Default SC 5.0.1 slow response on probsummary queries

    Query returns on probsummary has slowed down a notch. When I did an LFScan, it found...
    Total of 90896 bytes (0.0%) inaccessible in 165 holes

    I'm not sure if this is the cause of the performance issue. Is there any way to fix this error?
    Any suggestions on what else I should be looking at? Choosing option in SCDBUtil <A> Scan and Fix P4 did not help fix the problem.

  2. #2
    Senior Member
    Join Date
    Jul 2006
    Location
    San Francisco, CA
    Posts
    172

    Default

    To reclaim the space you'd need to run an LFMAP.
    But it is highly unlikely that this is the cause of the problem: there is less than a tenth of one percent of space affected.
    --Have you investigated whether the probsummary keys are appropriate?

  3. #3
    Senior Member glg's Avatar
    Join Date
    Aug 2004
    Location
    Chicago, IL, USA
    Posts
    715

    Default

    A hole occurs when a record is deleted, then a slightly smaller record is put into its place. That leaves an amount of space that's too small to put another record into. 90kb over an entire file is negligible. jstagaman is absolutely right. you could fix it with lfmap, but it's not your problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts