Hi Jeff,
The case insensitivity of the index should not impact the performance. The
number of indexes and their size will as the server need to insert the new
value in all of them during an insert.
As there is no standard way for specifying case insensitivity (not even to
define case insensitivity since it is locale dependant), you will need to add
custom SQL to your migration.
I use this pattern in my migration classes for these purpose:
// First line of the update method:
NSMutableArray<String> updateScript = new NSMutableArray<String>();
// After the table creation methods or even within for LocalDateTime attribute:
updateScript.add("ALTER COLUMN \"Intranet\".\"Bureau\".\"nom\" TO COLLATE
\"CaseInsensitive\";");
...
updateScript.add("SET UNIQUE = 0 FOR TypeRessource;");
...
// After the add foreign key constraint:
for (String sql : updateScript) {
ERXJDBCUtilities.executeUpdateScript(database.adaptorChannel(), sql);
}
Regards,
Samuel
> Le 24 mars 2017 à 13:46, Jeff Schmitz <[email protected]> a écrit :
>
> Just a quick question on how to create a case insensitive unique index in an
> ERXMigration? e.g. I’d like to apply it to the below index.
>
> ERXMigrationColumn[] entryColumns = {
> entryTable.existingColumnNamed("poolID"),
> entryTable.existingColumnNamed("c_name") };
> entryTable.addUniqueIndex("poolUniqueEntry", entryColumns);
>
> Also, how much is using a case insensitive unique index likely to affect
> performance on inserts?
>
> Thanks!
> Jeff
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list ([email protected])
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com
>
> This email sent to [email protected]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
