× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



When very large files meet interactive needs, I don't see how you can avoid
creating a permanent access path for each necessary view.   If the system
you are working on is powerful enough to dynamically create the SQL views
without adversely impacting system peformance, it will even more easily
accomodate the seven permanent access paths.  -Dave K.

----- Original Message ----- 
> There is a Work-with panel that contains about 7 fields, all of which the
> end-user wants to be able to sort by.
>
> Nothing to unusual about this so far.
>
> But in this situation the file is actually a dynamic file created with an
> SQL UNION ALL statement that ends up producing about 9 million records.
>
> I was thinking about a page=size subfile and will offer the end user a
> filtering option to weed out unwanted transactions.
>
> What I'm wondering is how to attack the subfile sort in this context; 9
> million records+ doesn't lend itself well to any conventional techniques,
> such as sorting a multiple occurrence data structure or even
dynamic/runtime
> querying via SQL or Open Query File as the performance will suck.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.