35
I have a question regarding flexible fields, with two possible outcomes:
Case #1: flexible fields can be the size of 65,535 characters, but the size will slow down the module when using the search or filter function within efqdirectory. Also getting the data for showing a listing will be slower because of a lack of indexing.
Case #2: flexible fields will have a maximum size of 255 characters. The possibilty of indexing these fields and the smaller size of the column will increase speed dramatically on search and filter funtions, yet the data fields are limited to a smaller size.
I would like to know your preferences so that I can make the decision. My advise would be to use the maximum size of 255 characters because of the speed issue. By default you will have the possibilty to use one big text field for the description of the listing. Any large texts should be added to this field, such as a description of the rooms in case of a hotel listing.
Please let me know what you think about this.
Martijn