On 2012-03-26, at 12:57 PM, Kevin Hinkson wrote:
> Hi Chuck,
> On 26 Mar 2012, at 15:36, Chuck Hill wrote:
>
>>> Hi all,
>>> I have been playing with Apache Bench to determine at what number of
>>> concurrent sessions/request load my app starts to fail and to find and
>>> reduce any bottlenecks.
On 26 Mar 2012, at 16:41, Ramsey Gurley wrote:
> I won't be giving JMeter the in depth coverage Chuck did, but if your app
> uses component actions, you'll probably want to know about persistent session
> storage.
Persistent session storage... sounds like magic to me.
— K.R.H.
___
On Mar 26, 2012, at 12:57 PM, Kevin Hinkson wrote:
> Hi Chuck,
>
> On 26 Mar 2012, at 15:36, Chuck Hill wrote:
>
>>> Hi all,
>>> I have been playing with Apache Bench to determine at what number of
>>> concurrent sessions/request load my app starts to fail and to find and
>>> reduce any bottl
Le 2012-03-26 à 15:57, Kevin Hinkson a écrit :
> Hi Chuck,
>
> On 26 Mar 2012, at 15:36, Chuck Hill wrote:
>
>>> Hi all,
>>> I have been playing with Apache Bench to determine at what number of
>>> concurrent sessions/request load my app starts to fail and to find and
>>> reduce any bottlenec
On 26 Mar 2012, at 15:31, Pascal Robert wrote:
> For stress testing:
> http://www.wocommunity.org/podcasts/wowodc/2010/WOWODC2010JMeter.mov
Thanks Pascal.
— K.R.H.
___
Do not post admin requests to the list. They will be ignored.
Webobjec
Hi Chuck,
On 26 Mar 2012, at 15:36, Chuck Hill wrote:
>> Hi all,
>> I have been playing with Apache Bench to determine at what number of
>> concurrent sessions/request load my app starts to fail and to find and
>> reduce any bottlenecks.
>
> Be aware that this is not easy and that setting up t
he tests and getting them
to run in a realistic simulation of actual load is not trivial.
> The first thing I run into is the "No instance available error".
That may just mean it overwhelmed your app.
> Does anyone have pointers for stress testing a webobjects app and determi
For stress testing:
http://www.wocommunity.org/podcasts/wowodc/2010/WOWODC2010JMeter.mov
> Hi all,
> I have been playing with Apache Bench to determine at what number of
> concurrent sessions/request load my app starts to fail and to find and reduce
> any bottlenecks. The first
;No instance available
> error". Does anyone have pointers for stress testing a webobjects app and
> determining what the bottlenecks are? Do the http adaptor settings play a big
> role in scaling up an app?
>
> — K.R.H.
>
> __
il and to find and reduce
> any bottlenecks. The first thing I run into is the "No instance available
> error". Does anyone have pointers for stress testing a webobjects app and
> determining what the bottlenecks are? Do the http adaptor settings play a big
> role in
Hi all,
I have been playing with Apache Bench to determine at what number of concurrent
sessions/request load my app starts to fail and to find and reduce any
bottlenecks. The first thing I run into is the "No instance available error".
Does anyone have pointers for stress testing a
Thanks Kieran. I've implemented your solution and will roll it through to prod
within a couple of days. I have deadlocks on at least a daily basis so if
those disappear it will be another validation of your work... not to mention
once again earning my gratitude.
Slán,
Jon
On 2/28/11 8:50 AM
Hi Jon,
On Feb 28, 2011, at 10:28 AM, Jon Nolan wrote:
> Hi Kieran,
>
> I have a multi-threaded app and I'm starting to run into deadlock issues on
> EC locking/unlocking (OSC really). After a weekend of digging and
> researching I think your solution is the answer.
>
> Question #1: Is this
Hi Kieran,
I have a multi-threaded app and I'm starting to run into deadlock issues on EC
locking/unlocking (OSC really). After a weekend of digging and researching I
think your solution is the answer.
Question #1: Is this the final, dust-settled version?
Question #2: Do you always use a n
Begin forwarded message:
> From: DANIEL BEATTY
> Date: December 4, 2009 6:32:28 PM PST
> To: Miguel Arroz
> Bcc: DANIEL BEATTY
> Subject: Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was
> Re: WebObjects stress Testing tool?]]
>
> Gr
On Dec 5, 2009, at 1:40 AM, Lachlan Deck wrote:
> On 05/12/2009, at 12:02 AM, Ramsey Lee Gurley wrote:
>
>> Hi Kieran,
>>
>> Have you tried vertical inheritance with MySQL?
>
> He wouldn't have. I have and continue to.
>
>> I have Animal->Cat->Leopard. I try to create a leopard and it fails b
Another PRO for postgresql: language for writing stored procedures.
A PRO for Oracle: OLAP implementation.
JPM
___
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/
On 05/12/2009, at 6:29 AM, Chuck Hill wrote:
> On Dec 4, 2009, at 11:16 AM, Kieran Kelleher wrote:
>
>> So, to sum up the pros and cons we heard in the discussion:
>>
>> FOR MySQL
>> - Free
>
> So is PG, FrontBase, and others so no a major Pro
>
>> - Easy to setup and configure
>
> Uh, it doe
On 05/12/2009, at 12:02 AM, Ramsey Lee Gurley wrote:
> Hi Kieran,
>
> Have you tried vertical inheritance with MySQL?
He wouldn't have. I have and continue to.
> I have Animal->Cat->Leopard. I try to create a leopard and it fails because
>
> com.webobjects.eoaccess.EOGeneralAdaptorException:
On 04/12/2009, at 11:17 PM, Kieran Kelleher wrote:
> Fair enough. Finally, we have one specific strike against it. ;-)
Two actually. Non transactional ddl operations.
> Since we have Delete rules in the EOModel, is this feature a "safety net"
> that is needed for external non-WO apps that are a
On Dec 4, 2009, at 7:07 PM, Guido Neitzer wrote:
On 4. Dec. 2009, at 17:46 , Mike Schrag wrote:
That's what I'm referring ... I have not used it, only read about
it enough to be intrigued by it. It requires your entire database
to be loaded into memory, but memory is pretty damn cheap. If
On 4. Dec. 2009, at 18:23 , Kieran Kelleher wrote:
>> Hmmm. Way back when we used it, it wasn't reliable. Every now and then
>> slaves had to be completely rebuild. And it also wasn't straightforward as
>> soon as something wasn't as expected.
>
> In 4.1 there was the occasional hiccup where yo
On 4. Dec. 2009, at 17:46 , Mike Schrag wrote:
> That's what I'm referring ... I have not used it, only read about it enough
> to be intrigued by it. It requires your entire database to be loaded into
> memory, but memory is pretty damn cheap. If you have a truly HUGE database,
> this is not an
On Dec 4, 2009, at 6:27 PM, Kieran Kelleher wrote:
Wow, did not realize full-featured FB was free - makes it worth
looking at now
Damn we are a cheap bunch!:-)
It is has been free for a few years now. Definitely a contender.
- however if Mike S started using MySQL, then switching is
On Dec 4, 2009, at 8:27 PM, Guido Neitzer wrote:
On 4. Dec. 2009, at 16:48 , Ramsey Lee Gurley wrote:
[Free]
So is PG, FrontBase, and others so no a major Pro
MySQL Administrator is pretty nice to have. At least I don't have
to shell out $150 on Navicat. Does postgres/frontbase/other h
Wow, did not realize full-featured FB was free - makes it worth
looking at now - however if Mike S started using MySQL, then switching
is unlikely because MySQL integration will only get better! ;-)
On Dec 4, 2009, at 2:29 PM, Chuck Hill wrote:
FOR MySQL
- Free
So is PG, FrontBase, and ot
On Dec 4, 2009, at 8:11 PM, Guido Neitzer wrote:
On 4. Dec. 2009, at 11:16 , Kieran Kelleher wrote:
So, to sum up the pros and cons we heard in the discussion:
FOR MySQL
- Free
- Easy to setup and configure
- Clustering engine
I have read a bit about this part as I'm always curious about
Hey!
On 2009/12/05, at 01:46, Mike Schrag wrote:
And I'm not talking about asynchronous replication, I'm talking
about real multi-master cluster with guaranteed integrity.
That's what I'm referring ... I have not used it, only read about it
enough to be intrigued by it. It requires your enti
>> So, to sum up the pros and cons we heard in the discussion:
>>
>> FOR MySQL
>> - Free
>> - Easy to setup and configure
>> - Clustering engine
>
> I have read a bit about this part as I'm always curious about synchronous
> multi-master clustering support in DBs. From Are people here referring
On Dec 4, 2009, at 5:27 PM, Guido Neitzer wrote:
On 4. Dec. 2009, at 16:48 , Ramsey Lee Gurley wrote:
[Free]
So is PG, FrontBase, and others so no a major Pro
MySQL Administrator is pretty nice to have. At least I don't have
to shell out $150 on Navicat. Does postgres/frontbase/other hav
On 4. Dec. 2009, at 17:20 , Chuck Hill wrote:
> On Dec 4, 2009, at 5:11 PM, Guido Neitzer wrote:
>>>
>>> AGAINST MySQL
>>> - Lack of deferred constraints
>>> - Lack of transactional DDL (roll back failing migrations for example). As
>>> Mike pointed out, neither does Oracle, so not alone there.
On 4. Dec. 2009, at 16:48 , Ramsey Lee Gurley wrote:
[Free]
>> So is PG, FrontBase, and others so no a major Pro
>
>
> MySQL Administrator is pretty nice to have. At least I don't have to shell
> out $150 on Navicat. Does postgres/frontbase/other have decent free tools?
PGAdmin always did wh
On Dec 4, 2009, at 5:11 PM, Guido Neitzer wrote:
AGAINST MySQL
- Lack of deferred constraints
- Lack of transactional DDL (roll back failing migrations for
example). As Mike pointed out, neither does Oracle, so not alone
there.
All toys ... :-P
Now, now Guido. Oracle is not a toy. It
On Dec 4, 2009, at 4:48 PM, Ramsey Lee Gurley wrote:
On Dec 4, 2009, at 2:29 PM, Chuck Hill wrote:
On Dec 4, 2009, at 11:16 AM, Kieran Kelleher wrote:
So, to sum up the pros and cons we heard in the discussion:
FOR MySQL
- Free
So is PG, FrontBase, and others so no a major Pro
MySQL
On 4. Dec. 2009, at 11:16 , Kieran Kelleher wrote:
> So, to sum up the pros and cons we heard in the discussion:
>
> FOR MySQL
> - Free
> - Easy to setup and configure
> - Clustering engine
I have read a bit about this part as I'm always curious about synchronous
multi-master clustering support
On Dec 4, 2009, at 2:29 PM, Chuck Hill wrote:
>
> On Dec 4, 2009, at 11:16 AM, Kieran Kelleher wrote:
>
>> So, to sum up the pros and cons we heard in the discussion:
>>
>> FOR MySQL
>> - Free
>
> So is PG, FrontBase, and others so no a major Pro
MySQL Administrator is pretty nice to have.
On Dec 4, 2009, at 10:54 AM, Guido Neitzer wrote:
On 4. Dec. 2009, at 09:43 , Kieran Kelleher wrote:
Hi Guido shiver? is it that cold in California? ;-)
Yeah, it actually is in the morning. At least it feels like this
after a lng summer.
Fair points. This has been a good
On Dec 4, 2009, at 11:16 AM, Kieran Kelleher wrote:
So, to sum up the pros and cons we heard in the discussion:
FOR MySQL
- Free
So is PG, FrontBase, and others so no a major Pro
- Easy to setup and configure
Uh, it does not work correctly out of the box so I think this is a con
- Clu
So, to sum up the pros and cons we heard in the discussion:
FOR MySQL
- Free
- Easy to setup and configure
- Clustering engine
- Easy reliable replication
AGAINST MySQL
- Lack of deferred constraints
- Lack of transactional DDL (roll back failing migrations for
example). As Mike pointed out, n
On 4. Dec. 2009, at 09:43 , Kieran Kelleher wrote:
> Hi Guido shiver? is it that cold in California? ;-)
Yeah, it actually is in the morning. At least it feels like this after a
lng summer.
> Fair points. This has been a good discussion.
>
> What is the workaround ... is it t
On Dec 4, 2009, at 10:19 AM, Kieran Kelleher wrote:
Not to mention the small issue of indexes. So Kieran, you are
manually creating indexes to compensate for lack of FK constraints?
Yes I am :-)... now the achilles heel of MySQL has been
exposed!
Wow. Uh. Speechless. Me!
On Dec 4, 2009, at 12:49 PM, Chuck Hill wrote:
On Dec 4, 2009, at 6:48 AM, David Avendasora wrote:
On Dec 4, 2009, at 9:19 AM, Kieran Kelleher wrote:
The lack of deferred constraints prevents one using foreign key
constraints in MySQL (InnoDB specifically supports FK
constraints). The
On Dec 4, 2009, at 6:27 AM, Kieran Kelleher wrote:
I don't use EOModel inheritance any more. It is a PITA. Not worth
the hassle.
I've never found that to be the case. What trouble were you having?
Chuck
Using Strategy design pattern to composite in different behaviours
works better for
On Dec 4, 2009, at 9:43 AM, Kieran Kelleher wrote:
Hi Guido shiver? is it that cold in California? ;-)
Fair points. This has been a good discussion.
What is the workaround ... is it that we must write a delegate
to do ordering of updates like Chuck did for MS SQL Server? Is th
On Dec 4, 2009, at 6:48 AM, David Avendasora wrote:
On Dec 4, 2009, at 9:19 AM, Kieran Kelleher wrote:
Actually, let me rephrase that. My brain was not working earlier
since I had not yet had breakfast :-)
M. Guinness!
Damn! That was MY line you just used!
The lack of deferred c
On Dec 4, 2009, at 6:21 AM, Kieran Kelleher wrote:
Ramsey,
Just remove the FK constraints in MySQL. WO works fine without them
since EOF takes care of it. If a database does not support deferred
constraints, then you should not add FK constraints at all.
I once advocated that too, long
On Dec 4, 2009, at 5:02 AM, Ramsey Lee Gurley wrote:
Hi Kieran,
Have you tried vertical inheritance with MySQL? I have Animal->Cat-
>Leopard. I try to create a leopard and it fails because
com.webobjects.eoaccess.EOGeneralAdaptorException:
EvaluateExpression failed: $MySQLExpression: "I
Hi Guido shiver? is it that cold in California? ;-)
Fair points. This has been a good discussion.
What is the workaround ... is it that we must write a delegate to
do ordering of updates like Chuck did for MS SQL Server? Is that
right? Chuck?
-Kieran
On Dec 4, 2009, at 12:04
Why does this make me shiver? I'd like to have my DB take care of structural
integrity for me as
1) I will make coding mistakes,
2) It is rare, that ONLY WO touches a DB,
3) I will not rely on EOF always doing the thing I expect it to do.
Not having FK constraints is about as wrong as using MyI
On Dec 4, 2009, at 9:19 AM, Kieran Kelleher wrote:
> Actually, let me rephrase that. My brain was not working earlier since I had
> not yet had breakfast :-)
M. Guinness!
> The lack of deferred constraints prevents one using foreign key constraints
> in MySQL (InnoDB specifically supports
On Dec 4, 2009, at 9:33 AM, Kieran Kelleher wrote:
> and boy is it easy to add new flavors of behaviour ...
You've been on this side of the pond too long. You are mixing your
misspellings. :-P
Dave
David Avendasora
Senior Software Engineer
K12, Inc.
*
WebObjects Documentation Wiki :
On Dec 4, 2009, at 9:19 AM, Kieran Kelleher wrote:
> Actually, let me rephrase that. My brain was not working earlier since I had
> not yet had breakfast :-)
M. Guinness!
> The lack of deferred constraints prevents one using foreign key constraints
> in MySQL (InnoDB specifically supports
and boy is it easy to add new flavors of behaviour ... no need to
touch the EOModel if the attributes are the same or a subset of the
EO's attributes.
On Dec 4, 2009, at 9:27 AM, Kieran Kelleher wrote:
I don't use EOModel inheritance any more. It is a PITA. Not worth
the hassle. Using
I don't use EOModel inheritance any more. It is a PITA. Not worth the
hassle. Using Strategy design pattern to composite in different
behaviours works better for me. Remember the OO Principle "Favor
composition over inheritance" ... I now favor composition over
inheritance ;-) BTW, for th
Ramsey,
Just remove the FK constraints in MySQL. WO works fine without them
since EOF takes care of it. If a database does not support deferred
constraints, then you should not add FK constraints at all.
Cheers, Kieran
On Dec 4, 2009, at 8:02 AM, Ramsey Lee Gurley wrote:
Hi Kieran,
Have
Actually, let me rephrase that. My brain was not working earlier since
I had not yet had breakfast :-)
The lack of deferred constraints prevents one using foreign key
constraints in MySQL (InnoDB specifically supports FK constraints).
The problem is that MySQL will not let you delete relate
On Dec 4, 2009, at 8:02 AM, Ramsey Lee Gurley wrote:
> Hi Kieran,
>
> Have you tried vertical inheritance with MySQL? I have Animal->Cat->Leopard.
> I try to create a leopard and it fails because
>
> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed:
> Leopard(s
Hi Kieran,
Have you tried vertical inheritance with MySQL? I have Animal->Cat->Leopard.
I try to create a leopard and it fails because
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed:
:
Next exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or
On Dec 4, 2009, at 7:17 AM, Kieran Kelleher wrote:
> Fair enough. Finally, we have one specific strike against it. ;-)
>
> Since we have Delete rules in the EOModel, is this feature a "safety net"
> that is needed for external non-WO apps that are accessing the database?
What do you mean? That
Fair enough. Finally, we have one specific strike against it. ;-)
Since we have Delete rules in the EOModel, is this feature a "safety
net" that is needed for external non-WO apps that are accessing the
database? I have never implemented constraints and have yet to have an
orphan record sin
On 4 dec 2009, at 09:54, Tim Worman wrote:
> Mark:
>
> Yeah, you can use any ODBC data source to use the import functionality and
> script steps. However, FileMaker Pro 10 now has the ability to transparently
> use tables from an external data source as though they were internal tables.
> But
Mark:
Yeah, you can use any ODBC data source to use the import functionality and
script steps. However, FileMaker Pro 10 now has the ability to transparently
use tables from an external data source as though they were internal tables.
But it can only do this with SQL Server, Oracle, and MySQL.
Hi Tim,
I have accessed PostgreSQL using Filemaker before using ODBC using
"Actual" drivers.
Caveat: I only used this with 8.0 and 8.5 using ODBC to import all
data for subsequent processing rather than accessing data "live". I
gather Filemaker 9.0 can use an external data source in joins, but
ha
On Dec 3, 2009, at 5:44 PM, Lachlan Deck wrote:
On 04/12/2009, at 12:25 PM, Kieran Kelleher wrote:
I was just wondering why people were saying disaster, toy, etc
wondering if I am missing something and going to lose all my data
next week!
Like I said, I have not used FrontBase or Po
I don't think I ever used MyISAM tables with a WO app. I have seen corrupted
data with InnoDB tables and WO usage though. For the rest, they might have been
MyISAM used from some PHP web crap, but the thing is: the SQL stored the thing
and some historic data gets corrupted. That was the issue we
On 3. Dec. 2009, at 17:25 , Kieran Kelleher wrote:
[...]
> What would I like that I think I might be missing?
> - transactional structure changes (ie., create table and roll back.)
> transactions in InnoDB only apply to table/record edits themselves.
So that is probably what screwed my migration
On 04/12/2009, at 12:25 PM, Kieran Kelleher wrote:
> I was just wondering why people were saying disaster, toy, etc wondering
> if I am missing something and going to lose all my data next week!
>
> Like I said, I have not used FrontBase or PostgreSQL in production and have
> never touched
Hi!
On 2009/12/04, at 01:25, Kieran Kelleher wrote:
I was just wondering why people were saying disaster, toy, etc
wondering if I am missing something and going to lose all my data
next week!
Most probably... ;)
For me, it's the same discussion between Linux and FreeBSD. Linux
I was just wondering why people were saying disaster, toy, etc
wondering if I am missing something and going to lose all my data next
week!
Like I said, I have not used FrontBase or PostgreSQL in production and
have never touched PostgreSQL, so if it is comparison you are after, I
do
I have seen screwed up data from people using default MyISAM tables.
Not transactional tables. So basically if your EC saveChanges fails,
there is no rollback, so now you have a half-committed save . yes,
using the default MyISAM engine *will* screw up your data big
time and that i
I have been extremely pleased with it. I have not had any strange problems with
modeling, data type/WO compatibility. Were it not for the aforementioned
pressure to include FileMaker Pro as a report writer, I'd probably not be
looking away from it at all. Although, it does cost money and times a
It is probably better to look at the flip side: what are my reasons
FOR using this database instead of any other database?
On Dec 3, 2009, at 2:58 PM, Kieran Kelleher wrote:
Miguel, anyone, please enlighten me as to what specifically is wrong
with using MySQL InnoDB as a database for WO bec
) 939-7097
-Original Message-
From: webobjects-dev-bounces+daniel.beatty=navy@lists.apple.com on behalf
of André Mitra
Sent: Thu 12/3/2009 4:14 PM
To: WebObjects Development
Subject: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re:WebObjects stress
Testing tool?]
So, w
So, why not use OpenBase? Or does it have to be free...
On 2009-12-03, at 6:20 PM, Mike Schrag wrote:
> Also, full disclosure -- i DO use Postgresql and I think it's a great
> database, but I always feel a little queasy when I do a deployment with PG
> without clustering support. There's always
On Dec 3, 2009, at 4:07 PM, Pascal Robert wrote:
Le 09-12-03 à 18:29, Miguel Arroz a écrit :
Hi!
Q: Does PostgreSQL have replication?
A: Yes, currently we have a half-dozen different replication
tools, depending on the user's purpose and platform. This is
limited to master-slave replic
I saw some serious issues with MySQL and migrations lately, but haven't checked
where the actual reason might be. It looked like you can't create table, then
call existingTableNamed as this will return null. Also it actually created
tables and didn't roll back when the migration failed. I don't
Le 09-12-03 à 18:29, Miguel Arroz a écrit :
Hi!
Q: Does PostgreSQL have replication?
A: Yes, currently we have a half-dozen different replication tools,
depending on the user's purpose and platform. This is limited to
master-slave replication in mature open source projects, including
bu
jects Development
Subject: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re:WebObjects stress
Testing tool?]
I'm also staring down a future with MySQL - for a much different reason. Our
school has a lot of institutional knowledge of FileMaker Pro. I'm moving
towards WO as
I'm also staring down a future with MySQL - for a much different reason. Our
school has a lot of institutional knowledge of FileMaker Pro. I'm moving
towards WO as the editing mechanism and leveraging that institutional knowledge
for users' report writing needs. FMP only supports 3 databases for
They're adding REPLICATION in 2010, not clustering ... Most replication systems
are asynchronous and, as a result, don't guarantee transaction commitment to
the replicants in the event of a failure, which means it's not really a
suitable option for fail-over/ha, only for backups. Bucardo is new
That is awesome. If MySQL is in your future, the Wonder support will
only get better ;-)
Hey Miguel, FUD, FUD, FUD! ;-)
On Dec 3, 2009, at 6:20 PM, Mike Schrag wrote:
Also, full disclosure -- i DO use Postgresql and I think it's a
great database, but I always feel a little queasy when I do
Hi!
Q: Does PostgreSQL have replication?
A: Yes, currently we have a half-dozen different replication tools,
depending on the user's purpose and platform. This is limited to
master-slave replication in mature open source projects, including
built-in PITR and Slony-I. Multi-master replicati
Hi!
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00913.php
I don't know if it made into 8.4 or not, but they eventually
understood they needed a better solution.
Yours
Miguel Arroz
On 2009/12/03, at 23:20, Mike Schrag wrote:
Also, full disclosure -- i DO use Postgresql an
Also, full disclosure -- i DO use Postgresql and I think it's a great database,
but I always feel a little queasy when I do a deployment with PG without
clustering support. There's always the feeling of "i sure hope this doesn't
screw me." FrontBase has clustering, but has an obnoxious bug with
Caveat here -- I don't use MySQL (yet) for anything real. InnoDB is acid,
though. I agree that you should never run a myisam mysql for most normal
systems and that it's strange that this is the default, but the fact is that
you CAN set it to innodb, and it's a perfectly capable (if not VERY ca
Hi!
There is nothing "specifically" wrong about using MySQL as a
database for WO. What's wrong is using MySQL at all! ;)
Essentially, it sucks. The first concern of MySQL authors is speed,
and only then correctioness. This may be seen my the existence of
InnoDB itself. First, spee
with MySQL 5, I don't think there's any reason to believe it's less of a
database ... in particular, mysql's has an actual clustering implementation
whereas pg has a failure pile in a sadness bowl.
http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
this seems to be a reasonably up-to-date compariso
Miguel, anyone, please enlighten me as to what specifically is wrong
with using MySQL InnoDB as a database for WO because I have not seen
any problem, but then I have not used PostgreSQL or FrontBase either -
so maybe I don't see a problem that I should be concerned about.
-Kieran
On Dec 3
>>> 3) If you use OSC synchronization (ERXOSCSynchronizer and ERJGroupsSync)
>>> you will still haev the problem of snapshots changing underneath you if you
>>> don't lock the OSC. So IMHO, the OptimisticLockAction approach works well
>>> . and if the approach "ain't broke, why fix it" :-)
>
On Dec 3, 2009, at 2:41 PM, Miguel Arroz wrote:
On 2009/12/03, at 22:32, Kieran Kelleher wrote:
I create new OSCs for most background tasks. The one thing is
that I dispose() on it at the end of the task and the
dispose() is only useful if you use ERXJDBCAdaptor is used since
the reg
Hi!
On 2009/12/03, at 22:32, Kieran Kelleher wrote:
I create new OSCs for most background tasks. The one thing is that
I dispose() on it at the end of the task and the dispose() is
only useful if you use ERXJDBCAdaptor is used since the regular WO
5.3 jdbc adaptor opens two connection
On Dec 3, 2009, at 4:06 PM, Miguel Arroz wrote:
Hi!
On 2009/12/03, at 20:53, Kieran Kelleher wrote:
1) Yes, there is a ERXJDBCConnectionBroker that does what you say.
I have not used it though.
I must check that.
2) Creating another OSC is not much overhead (IMHO) itself ..
it is
Hi!
On 2009/12/03, at 20:53, Kieran Kelleher wrote:
1) Yes, there is a ERXJDBCConnectionBroker that does what you say. I
have not used it though.
I must check that.
2) Creating another OSC is not much overhead (IMHO) itself .. it
is all the EO's and snapshots that are the overhead.
1) Yes, there is a ERXJDBCConnectionBroker that does what you say. I
have not used it though.
2) Creating another OSC is not much overhead (IMHO) itself .. it
is all the EO's and snapshots that are the overhead. I create new OSCs
for most background tasks. The one thing is that I dispos
Hi!
I don't know EOF at that level well enough, although that might
work. However, it's a little dirty... :) I would prefer something a
little more integrated in the EOF architecture (that might have to
evolve a little). Maybe separating the OSC from the DB connections, so
that several
OK, this is the final concurrent utility code to provide manual
locking ec's in a app with safeLocking on. And just for fun and
Ricardo's enjoyment of anonymous classes ;-), the factory is an
anonymous static class and its _create method returns anonymous
ERXEC's with the two methods over-r
i think we're talking two different things ... if you have an empty superclass
constructor and you don't declare any constructors, then yes, there is an
implicit constructor created in your subclass that calls super (as well, if you
DO declare a constructor and there is an empty super constructo
yeah, good point -- probably making a real subclass as well as a custom factory
subclass and doing YourFactory.newEditingContext() would be slightly safer, in
case the superclass factory is attaching delegates or something.
ms
On Dec 3, 2009, at 2:38 PM, Kieran Kelleher wrote:
> True, but then
Don't subclasses have an implicit super() to invoke the super class constructor?
On Dec 3, 2009, at 2:38 PM, Kieran Kelleher wrote:
> True, but then I would be bypassing the EC factory, which just seems dirty,
> but yes, this very good suggestion is an elegant way to do it for sure.
>
> On Dec
True, but then I would be bypassing the EC factory, which just seems
dirty, but yes, this very good suggestion is an elegant way to do it
for sure.
On Dec 3, 2009, at 2:16 PM, Anjo Krank wrote:
PS. And even the above is not perfect protection against an
autolock if a thread gets cpu execut
1 - 100 of 117 matches
Mail list logo
