Subject | AW: [firebird-support] performance question |
---|---|
Author | Olaf Kluge |
Post date | 2012-04-17T09:40:39Z |
Hello Set,
Best thanks for your detailed reply.
Yes, in my table exists fiest a primary key with a integer value generated
by a trigger and a generator. All values can be alphanumeric, so that I must
save all data in separate character-fields (approx. 100 columns). I could
create a separate table for each column (1 to n). That would be too much
effort and I don't have all possible combinations. This could be automated
too, but how I said, much effort. I will put all information into separate
columns.
Thank you.
Best regards.
[Non-text portions of this message have been removed]
Best thanks for your detailed reply.
Yes, in my table exists fiest a primary key with a integer value generated
by a trigger and a generator. All values can be alphanumeric, so that I must
save all data in separate character-fields (approx. 100 columns). I could
create a separate table for each column (1 to n). That would be too much
effort and I don't have all possible combinations. This could be automated
too, but how I said, much effort. I will put all information into separate
columns.
Thank you.
Best regards.
[Non-text portions of this message have been removed]