I am tired, confused, and i need to figure out how to get my code working
properly on the test server.
I am sure one of you deployment/Jenkins gurus could probably figure this out in
15 mins. I have
spent 16 hours and am more confused then ever.
Pascal? Davids? Anyones?
James
smime.p7s
De
Hi Jesse
LOL I just meant for easy inspection in BBEdit (or even a printout) to identify
(or highlight on paper) all FKs that need a Index! :-)
Regards, Kieran.
(Sent from my iPhone)
On Mar 6, 2012, at 1:34 PM, David LeBer wrote:
> Jesse,
>
> I don't think anyone said anything about dumpin
On 07/03/2012, at 4:57 AM, Jesse Tayler wrote:
> why would I have to dump my data just to create the indexes?
Don't.
> should I not be able to create indexes on the fly on mysql?
Yes. Add it to a migration (but verify it won't take forever).
> and yes, this is my first mysql setup and no, I di
oh!
just so as I can see things more easily eh?
whew.
I'm concerned that if we are unable to make decent indexes automatically, I'll
do a terrible job at it by hand!
I'd go in and basically setup indexes where I see foreign keys, my database
isn't fancy, but what else can or should I look to
Jesse,
I don't think anyone said anything about dumping your data.
Kieran said dump your 'schema' not data.
--
David LeBer
Codeferous Software
On 2012-03-06, at 12:57 PM, Jesse Tayler wrote:
> why would I have to dump my data just to create the indexes?
>
> should I not be able to create inde
Also check the many-to-many tables. At one point (and maybe still) these were
only half indexed. e.g. for a table with fkA and fkB, the index would be on
fkA, fkB. If the query used only fkB, it would no be optimized.
Chuck
On 2012-03-06, at 9:00 AM, Theodore Petrosky wrote:
> This conversa
On Mar 5, 2012, at 5:46 PM, David Avendasora wrote:
> But I'm not sure that all DB plugins create proper SQL for distinct queries.
> I remember having some issue with it in the past, especially with regards to
> using it on FetchSpecs that have EOSortOrderings with Oracle
> (http://issues.obje
why would I have to dump my data just to create the indexes?
should I not be able to create indexes on the fly on mysql?
and yes, this is my first mysql setup and no, I did NOT realize fully that I
had to create indexes - some have been, other not, it seems...
anyone have a nice - simple WO-per
This conversation has piqued my interest.
I just looked at my postgresql database to see what indexes are created in a
'normal' migration and I was happy to see that the foreign key did get an index:
Indexes:
"person_pk" PRIMARY KEY, btree (id)
"person_erattachmentid_idx" btree (erattachm
Some examples:
many to many join table
--
CREATE TABLE `xxprogramcsagency` (
`oidprogram` int(11) NOT NULL,
`oidagency` int(11) NOT NULL,
PRIMARY KEY (`oidprogram`,`oidagency`),
KEY `idx_agency_program` (`oidagency`,`oidprogram`)
) ENGINE=InnoDB;
regular tab
Whoa. yes, YOU MUST create foreign key indexes yourself in MySQL! (The auto
SQL from EntityModeler does not do it for you since creating true foreign key
constraints in MySQL is a rat's nest of problems due to the lack of the most
desired feature that MySQL lacks currently (deferred constrai
oh, the fetch kills the database alright -- I'll attempt to fix with indexes,
but I've had mixed luck with that.
I notice there's not all the indexes I'd expect on foreign keys? mysql have
anything funny there? or I should have at least an index for each foreign key,
no?
On Mar 6, 2012, at 8
Hello -
I got jenkins to build. Now what do I do?
Do I reconfigure Eclipse Wolips properties to point to it?
IF so, can someone send me a sample screen shot of theirs?
Next. I need the latest Prototype builds for my AJAX to work on IE.
How do I configure Jenkins or whatever to test, build and de
Prematurely looking for a fetch solution that does not overkill the database
when the we don't know if the fetch overkills the database yet. :-)
Regards Kieran
___
Sent from my iPad.
On Mar 5, 2012, at 9:44 PM, Paul Yu wrote:
> Premature what?
>
> --
> Paul Yu
> Sen
Another minor point:
It is Multiple SCMs Plugin
not Multi SCM
At 3:00am this makes a big difference!
James
On Mar 5, 2012, at 11:10 PM, David Avendasora wrote:
> Ah,
>
>
>
> On Mar 6, 2012, at 11:25 AM, James Cicenia wrote:
>
>> I am trying...
>>
>> Step 2 on the wiki to "git" the confi
no, we build on ec2 (jenkins running on ec2)
On 5 March 2012 17:03, John Huss wrote:
> Are you building with it on a Mac? If so, how?
>
> On Mon, Mar 5, 2012 at 10:40 AM, Simon wrote:
>>
>> We're building on it as well as deploying on it
>>
>>
>> On Monday, 5 March 2012, Paul Hoadley wrote:
>>>
16 matches
Mail list logo
