View Issue Details

IDProjectCategoryView StatusLast Update
0003278JEDI VCL00 JVCL Componentspublic2008-02-21 03:21
ReporternestorAssigned ToInformatix 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionsuspended 
Product Version 
Target VersionFixed in Version 
Summary0003278: jvDBGrid slow down when browsing or searching record.
DescriptionD7/Latest CVS
When linked data is PARADOX 7 table and using the primary index, jvDBGrid slow down when browsing or searching record.
This problem dosn’t appears when using secondary index of the same table.
No problem at all when using Borland TDBGrid, with the same table.
Table has more than 40,000 records.
TagsNo tags attached.

Activities

Informatix

2005-10-20 07:24

developer   ~0008042

Please attach a file (prog + db) showing the problem.

Fred

nestor

2005-10-20 10:57

reporter   ~0008043

TjvDBGrid Browsing slow down occurs when:
- OnFilterRecord is assigned
- Table.Filtered is set to False
- Paradox index is primary

Change Filtered to true or remove OnFilterRecord assignation remain browsing speed "normal".
See example uploaded.

2005-10-20 12:19

 

JvDBGridFilter.zip (3,276 bytes)

Informatix

2005-11-10 04:10

developer   ~0008079

Without a database with thousands of records, it is difficult to test. And I don't use Paradox DB, so...

Fred

nestor

2005-11-10 09:05

reporter   ~0008082

Test program( project2) create and add records to a paradox table as needed (click on "Add more records" button to append data).

You need just to have BDE administrator installed on your system and to install BDE component.

obones

2006-04-04 05:13

administrator   ~0008870

any news ?

nestor

2006-04-04 07:39

reporter   ~0008903

Always the same problem! Have no background to fix this bug in TjvDBGrid.
To save my self, I define a new property in my own project that assign “DataSet.OnFilterRecord” dynamically. Nil when Dataset.filtered is set to false, other ways the procedure object of “OnFilterRecord”.

Informatix

2006-06-30 07:39

developer   ~0009737

I don't use BDE at all and I don't have Delphi so I cannot help. The only thing I can say is that I don't see anything strange or slow with filters in JvDBGrid with my numerous ADO-based apps.

Fred (BCB5 user)

obones

2008-02-21 03:20

administrator   ~0014213

This issue is too old, many changes have been done in between. Should this still be applicable, please create a new issue after having tested using the latest JVCL

Issue History

Date Modified Username Field Change
2005-10-19 02:01 nestor New Issue
2005-10-20 07:24 Informatix Note Added: 0008042
2005-10-20 10:57 nestor Note Added: 0008043
2005-10-20 12:19 nestor File Added: JvDBGridFilter.zip
2005-11-10 04:10 Informatix Note Added: 0008079
2005-11-10 09:05 nestor Note Added: 0008082
2005-11-22 08:34 obones Status new => feedback
2006-04-04 05:13 obones Note Added: 0008870
2006-04-04 07:39 nestor Note Added: 0008903
2006-06-27 03:45 obones Status feedback => assigned
2006-06-27 03:45 obones Assigned To => Informatix
2006-06-30 07:39 Informatix Note Added: 0009737
2008-02-21 03:20 obones Status assigned => closed
2008-02-21 03:20 obones Note Added: 0014213
2008-02-21 03:21 obones Resolution open => suspended