• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))


  • Subject: Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))
  • From: OC <email@hidden>
  • Date: Tue, 20 Jan 2015 13:50:51 +0100

Samuel,

On 15. 1. 2015, at 14:49, Samuel Pelletier <email@hidden> wrote:

> 1- Store additional attributes in a serialized map structure (json, serialized php array, serialized java objects or property list).

Precisely what I did. Works well, but is unacceptably slow (even if I cache unarchived dictionaries in EOs, fetching and unarchiving just the first time).

> 2- Store the additional attributes in an dedicated entity with a commun dictionary of attribute definitions.

I use this approach in some specific cases (like e.g., file attachments), but to exploit it for all dynamic attributes I would fear all those joins would bring performance problems, too. Definitely I might be wrong, but I think a flat denormalized table would be consideraly faster.

Thanks,
OC


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden


  • Follow-Ups:
    • Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))
      • From: Samuel Pelletier <email@hidden>
References: 
 >ERXSQLHelper (From: OC <email@hidden>)
 >Re: ERXSQLHelper (From: Theodore Petrosky <email@hidden>)
 >Re: ERXSQLHelper (From: OC <email@hidden>)
 >Re: ERXSQLHelper (From: OC <email@hidden>)
 >Re: ERXSQLHelper (From: Timothy Worman <email@hidden>)
 >Re: ERXSQLHelper (From: OC <email@hidden>)
 >Re: ERXSQLHelper (From: Chuck Hill <email@hidden>)
 >Migrations (was: ERXSQLHelper) (From: OC <email@hidden>)
 >Re: Migrations (was: ERXSQLHelper) (From: Paul Hoadley <email@hidden>)
 >Model/DB synchronization (was: Migrations (was: ERXSQLHelper)) (From: OC <email@hidden>)
 >Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper)) (From: Paul Hoadley <email@hidden>)
 >Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper)) (From: OC <email@hidden>)
 >Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper)) (From: Ramsey Gurley <email@hidden>)
 >Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper)) (From: Samuel Pelletier <email@hidden>)

  • Prev by Date: Re: Remote Synchronizer exceptions
  • Next by Date: Re: Remote Synchronizer exceptions
  • Previous by thread: Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))
  • Next by thread: Re: Model/DB synchronization (was: Migrations (was: ERXSQLHelper))
  • Index(es):
    • Date
    • Thread