Is it possible to change the data (primary key) at the time of
replication?

That the replication process would get new primary keys and insert the
records using the new primary keys rather than the existing ones. This
would allow us to leave our application and database virtually the same.

Todd






Ann W. Harrison wrote:

>Todd Brasseur wrote:
>
>
>>We are very happy with how quick our application is and we think that
>>one of the reasons it is quick is because of the single integer primary
>>keys.
>>
>>Will moving to 2 part primary keys affect the speed of our queries?
>>
>>
>
>No, or rather, almost not at all. If the first part of the key is the
>server identifier and is, say, a two byte character field, then it will
>add only two bytes to each index page - which is almost nothing. The
>comparison of index keys is done bytewise, skipping compressed prefixes,
>so that won't be affected.
>
>Regards,
>
>
>Ann
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]