Hi ppl, Are there any set for create Indexes with configurable Page Size ? I have specific adt databases that need be created with 1024 Index Page Size.
I have my own ads1.c changed to do this, but IMO is important if we can have this configuration in set() or at the INDEX ON command. from ads doc: ---cut--- Advantage Proprietary Index files (ADIs) have a configurable page size, with a default of 512 bytes. There are some situations where it may be desirable to use larger page sizes. · As a general rule, tables with over one million records per table may benefit from larger index page sizes. Filters and SQL queries that include most of the records in the table may run faster with increased index page sizes. However, searches for single records or small subsets of the table probably would not benefit from larger page sizes. · Indexes with large keys may require larger page sizes. If the page size is not large enough, it may not be possible to create an index with longer keys. In addition, if the page size is too small, Advantage may not be able to balance the index properly, which could result in a 7022 error when updating the table. ---cut--- TIA and best regards, Toninho. _______________________________________________________ Yahoo! Mail - Sempre a melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/ _______________________________________________ Harbour mailing list [email protected] http://lists.harbour-project.org/mailman/listinfo/harbour
