Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
LIST(DISTINCT |
Sat, Dec 20 2014 10:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | If it doesn't screw anyone else up I'd like this changing so the distinct applies to individual values not to row values.
The reason is I store lists of various types in CLOB columns (eg user flags for contacts) and it would be useful to get a consolidated list of values that have been applied eg say one contact has the flags ONE TWO THREE and another ONE SEVEN TWELVE currently LIST(DISTINCT flags USING #13) would give me ONE TWO THREE ONE SEVEN TWELVE and I'd like to see ONE SEVEN TWO THREE TWELVE Roy Lambert |
Tue, Dec 23 2014 8:58 AM | Permanent Link |
Adam Brett Orixa Systems | Its a nice suggestion, but it would be a b*******d to run wouldn't it Roy?
Wouldn't it require in-memory parsing every CLOB of possibly a very large DB with the delimiter, turning this into a mega, mega list & sorting it. On a decent size table with lots of large CLOBs it would take bloody ages. |
Wed, Dec 24 2014 3:24 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>Its a nice suggestion, but it would be a b*******d to run wouldn't it Roy? > >Wouldn't it require in-memory parsing every CLOB of possibly a very large DB with the delimiter, turning this into a mega, mega list & sorting it. On a decent size table with lots of large CLOBs it would take bloody ages. Without knowing how Tim does it currently I have no real idea of what the impact would be, but I know there would be some. I'd be quite happy writing my own custom function (probably in Delphi) to bolt into the engine but I'm not sure what good practice would be to develop the equivalent of the LIST command. Roy Lambert |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |