Select to view content in your preferred language

One million codes for domain list for NG911 layers?

441
1
12-21-2023 08:17 AM
KeithJ
by
Occasional Contributor

Hello,

We are currently transitioning to a hybrid of NG911 and ADMS, with the recommended NG911 layers superseding ADMS and out current layers.

There a few fields that use a million code domain, numbers 0 to 999,999. That seems insane to me, but I wanted to reach out to the community to see if anyone has actually done this or something similar, and if so, what were the results? Do the number of codes slow down the processes?

Tags (3)
0 Kudos
1 Reply
Bud
by
Esteemed Contributor

What kind of database?

I don't have experience with large domains. But I did submit an idea related to the Oracle EGDB system tables (domains are stored in the system tables): Improve performance of SDE.GDB_ITEMS_VW by precomputing DEFINITION field

0 Kudos