Re: Globally unique IDs
Re: Globally unique IDs
- Subject: Re: Globally unique IDs
- From: Andy Satori <email@hidden>
- Date: Fri, 6 Feb 2004 14:08:22 -0500
I've been working with PostgresSQL and WO, and there is no question
that there are some 'issues' regarding it. I've been looking into
altering the plugin's that exist to address some of those issues.
I'm in a similar situation as you, I have a SQL Server database that
makes heavy usage of the GUID datatype in SQL Server, and I need it to
interop with the PosgresSQL database.
I have been using char(40) primary key fields in PostgresSQL to emulate
the SQL Server behaviour. This creates some issues with EO, and I
expect to have to deal with them via the plugin model. I believe that
these issues would face any of the current adaptors though.
Andy
On Feb 6, 2004, at 1:45 PM, Colin O'Brien wrote:
Hi,
we are working on a new system, where we will be moving data between
different databases.
This will require objects with a simple ID that is globally unique.
It seems the automatic private key mechanism in WO only provides
unique keys within a single database.
It seems we could get a truly unique ID using VMID.
It further seems we could create our own "PK's" in awakeFromInsertion.
The questions then would be
* is there going to be a noticeable performance hit using VMID's (40
bytes) compared to the more typical int?
more concerned about retrieval performance than update performance
* would it be better to use the built-in PK system and have a separate
column for the VMID?
particularly thinking about how relationships might work
We are planning on using MySQL.
We looked at both MySQL and PostgreSQL and while PostgreSQL seems the
better database system, MySQL seems better supported in WO.
Thanks for any help
Colin
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.