Suite Pro - Report: Sorting Large Numbers of Records

Print Page | Close Window

Report: Sorting Large Numbers of Records

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Suite Pro
Forum Description: Topics Related to Codejock Suite Pro
URL: http://forum.codejock.com/forum_posts.asp?TID=2010
Printed Date: 17 November 2024 at 9:53pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Report: Sorting Large Numbers of Records

Posted By: ianp
Subject: Report: Sorting Large Numbers of Records
Date Posted: 22 March 2005 at 10:23am

A report control contains 3 columns. These 3 columns are populated with 15,000 records.

Column 1: Primary key - 15000 unique values
Column 2: Descriptive Field - Duplicates OK, but mostly unique
Column 3: Category Text - one of 8 possible categories

Sorting column 1 is instantaneous, Column 2 slightly longer, but column 3 takes several seconds.

Unfortunately the control does not give any indication to the user that something is happening, often resulting in endless frustrated clicking.

Can this 'delay' in performance be trapped by a BeginSort event, or at the very least, change the mousepointer to let the user know there action has triggered an event of some sort?