20438 results


  • Comment:

    I'm not sure if this static test will answer our question, but maybe a good point to start.

    Comment to the post "Routine that converts indices to bitmap indices" by Dmitry Maslennikov, 8 days ago


  • Answer:

    I think we don't have any other possibilities how to catch changes in source code. Do you know how to catch if any object in any class was changed, outside of this class, if you don't have any triggers there? No easy task. But I think it is ...

    Answer to the post "Detecting Source Code Change?" by Dmitry Maslennikov, 15 hours 19 min ago


  • Comment:

    Ok, then, why it is so important, why I it is not recommend to use bitmap in case of so many unique values?

    Bitmap indices lose efficiency with a big number of distinct values.

    And what should be used instead?

    ...

    Comment to the post "Routine that converts indices to bitmap indices" by Eduard Lebedyuk, 8 days ago


  • Question: Import Ensemble backup into Iris

    Ensemble, InterSystems IRIS, Backup Hello, We are trying to migrate all our production to new IRIS servers. To test everything is working fine, and to be able to script the process, we want to import the data into new IRIS servers using a backup file ...

    Post by David Satorres 15 hours 56 min ago


  • Comment:

    2% or more means less than distinct 50 values.

    Thank you, Robert! New value for my list. I think I got 64 once but that's a new one.

    Comment to the post "Routine that converts indices to bitmap indices" by Eduard Lebedyuk, 8 days ago


  • Comment:

    I'm really surprised by this discussion.
    Especially having actual numbers. What should mean 6400 with just 15000 rows in total? Sorry, I oppose!
    It's a matter of selectivity.  If you can collect 2% of your records or...

    Comment to the post "Routine that converts indices to bitmap indices" by Robert Cemper, 8 days ago


  • Question: Detecting Source Code Change?

    Change management Is there a responsive way to detect a source code change without using a source control hook? Update I have my own custom unit test tool which has lots of extra functions that I find useful such as Asserting HL7 Transformers and REST ...

    Post by Sean Connelly 17 hours 17 min ago


  • Comment:

    Ok, then, why it is so important, why I it is not recommend to use bitmap in case of so many unique values? And what should be used instead?

    Comment to the post "Routine that converts indices to bitmap indices" by Dmitry Maslennikov, 8 days ago


  • Comment:

    That's the number I hear most often (5-10k rang) when I ask about maximum number of unique values for bitmap indices.

    I heard from a few hundred to 20k as a max value.

    Comment to the post "Routine that converts indices to bitmap indices" by Eduard Lebedyuk, 8 days ago


  • Comment:

    No, Ed indeed means number of unique values for indexed column.

    E.g. our docs advises no more than 10'...

    Comment to the post "Routine that converts indices to bitmap indices" by Alexander Koblov, 8 days ago