I agree.
I started working with WebObjects and databases in 2001 about and I know very
little about databases. I used MyISAM and after a while was a mess.
I moved then to OpenBase and everything fine. Later I moved to FrontBase that
was become free and I totally love it. It is fully transactiona
InnoDB is all or nothing . don't waste your time mixing InnoDB and MyISAM
in transactions - makes the results even more confusing.
Convert them all. evidently, InnoDB is faster nowadays anyway. innoDB can
cache everything in memory. MyISAM IIRC only can cache PKs in memory and must
alwa
Thanks Paul, it looks like you are correct.
Two 'Kieran Kelleher' email stated:
> There is also no row locking on EO_PK_TABLE with myisam, so you will get
> primary key clashes and subsequent failed inserts if the db is sufficiently
> contended.
and
> (1) Never use MyISAM - no transactional
Hi,
We have started getting more of these errors recently, now that the system is
under more load.
EvaluateExpression failed:
primaryKeyForNewRowWithEntity(EOEntity entity){
return null;
}
Any advise would be appreciated,
Thanks,
Mark
Ah! Missed that key little method.
Thanks
On May 17, 2013, at 11:04 AM, Jesse Tayler wrote:
>
> have you seen the method called dot() ?
>
> stuff like:
>
> (Article.AUTHOR.dot(User.POSTER_ID))
>
> dot rocks the box.
>
>
>
> On May 17, 2013, at 11:50 AM, James Cicenia wrote:
>
>> I am t
have you seen the method called dot() ?
stuff like:
(Article.AUTHOR.dot(User.POSTER_ID))
dot rocks the box.
On May 17, 2013, at 11:50 AM, James Cicenia wrote:
> I am trying to get handy with ERXKey.
>
> However, how does one go across relationships?
>
> Say I want to find all order items
I am trying to get handy with ERXKey.
However, how does one go across relationships?
Say I want to find all order items for a store:
It doesn't know to traverse ORDER_ERXKEY to the STORE_ERXKEY
OrderItems.ORDER_ERXKEY.STORE_ERXKEY.eq(store);
How does one properly construct this query?
Thanks