index CDX on the fly
in [Visual Objects]
|
Prev: Time flies....
Next: Serial comm in a VOService
From: Perfect Solution Software on 5 Jan 2010 10:39 I use DBF files with CDX indexes with a lot of tags. But sometimes you need to display data in different ways not included in any Tag index. The idea is create a temporary index on the fly, display the DBF data and then when the user closes the browser displaying the data delete the index. Does anyone use this approach?? regards Paolo Kalc
From: Ginny Caughey on 5 Jan 2010 10:53 Paolo, Generally the main DBF files I work with are too big for this to be a performant approach. When the user can ask for a subset of the data based on an index I already have such as date, I sometimes create temp DBF files and index to report that subset the way the user wants to see it. -- Ginny Caughey www.wasteworks.com "Perfect Solution Software" <infoNOSPAM1DELETE(a)magicorg.com> wrote in message news:4b435d31$0$694$5fc30a8(a)news.tiscali.it... > I use DBF files with CDX indexes with a lot of tags. > But sometimes you need to display data in different ways not included in > any Tag index. > The idea is create a temporary index on the fly, display the DBF data and > then > when the user closes the browser displaying the data delete the index. > Does anyone use this approach?? > > regards > Paolo Kalc >
From: Geoff Schaller on 5 Jan 2010 16:29 Paolo. No, bad idea. How many tags are we talking? 20 isn't too many. 30+ then I'd say you have a design issue <g>. Geoff "Perfect Solution Software" <infoNOSPAM1DELETE(a)magicorg.com> wrote in message news:4b435d31$0$694$5fc30a8(a)news.tiscali.it: > I use DBF files with CDX indexes with a lot of tags. > But sometimes you need to display data in different ways not included in any > Tag index. > The idea is create a temporary index on the fly, display the DBF data and > then > when the user closes the browser displaying the data delete the index. > Does anyone use this approach?? > > regards > Paolo Kalc
From: dlzc on 5 Jan 2010 16:57 Dear Perfect Solution Software: On Jan 5, 8:39 am, "Perfect Solution Software" <infoNOSPAM1DEL...(a)magicorg.com> wrote: > I use DBF files with CDX indexes with a lot > of tags. But sometimes you need to display > data in different ways not included in any > Tag index. > The idea is create a temporary index on > the fly, display the DBF data and then > when the user closes the browser displaying > the data delete the index. > Does anyone use this approach?? Let me make a suggestion. Copy just the key fields to a new temporary database, add a record pointer into the source file(s), and index that database. It'll be slower than creating an index alone, will in no way contaminate the "base" index, and will be really easy to delete. David A. Smith
From: Dirk (Belgium) on 6 Jan 2010 03:50
Perfect Solution Software wrote: > I use DBF files with CDX indexes with a lot of tags. > But sometimes you need to display data in different ways not included > in any Tag index. The idea is create a temporary index on the fly, > display the DBF data and then when the user closes the browser > displaying the data delete the index. Does anyone use this approach?? > > regards > Paolo Kalc Paolo, I do this all the time when creating reports. Just before sending the table to ReportPro, I create a separate CDX index (with filter conditions) and RP use this index with 1 tag inside for the report. Because this index only have the records which are really needed, I always have quick reports. Deleting this temporary index is just deleting a file on disk (after closing the table). Dirk -- |