On 4/18/07, John Siracusa <[EMAIL PROTECTED]> wrote:
> On 4/18/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
>> On Apr 18, 2007, at 10:22 AM, John Siracusa wrote:
>>> On 4/17/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
Though that can be handled using a strip helper alone too -- we'd
jus
On Apr 20, 2007, at 2:20 PM, John Siracusa wrote:
> On 4/20/07, James Masters <[EMAIL PROTECTED]> wrote:
>> how can I see exactly what select statement Rose is doing?
>
> Either turn on DBI->trace(...) or set these variables:
>
> $Rose::DB::Object::Debug = 1;
> $Rose::DB::Object::Manager:
On Apr 20, 2007, at 11:06 AM, John Siracusa wrote:
> On 4/19/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
>> Would it be terribly difficult to port:
>>
>> Rose::DB::Object::MixIn
>>
>> into
>>
>> Rose::Object::MixIn
>>
>> and then just having Rose::DB::Object::MixIn be a subcla
On 4/20/07, James Masters <[EMAIL PROTECTED]> wrote:
> how can I see exactly what select statement Rose is doing?
Either turn on DBI->trace(...) or set these variables:
$Rose::DB::Object::Debug = 1;
$Rose::DB::Object::Manager::Debug = 1;
The DBI approach is probably better, but also nois
That was a good idea, thanks. But the indexes seem to match on both
machines (in fact, the table in question only has the one).
I'm not familiar with these concepts but have started to look into it. I
see that in order to do 'explain', I must run it against the select
statement in question. I k
James Masters wrote:
> That is a suggestion of experience, thanks. I've analysed just done this
> and the results are not what you (& I) probably expected.
>
> I've tried all 4 combinations of server against mysql server. Numbers =
> secs.
>
> ServerMysql ServerDBI Rose
> Old
That is a suggestion of experience, thanks. I've analysed just done this
and the results are not what you (& I) probably expected.
I've tried all 4 combinations of server against mysql server. Numbers =
secs.
Server Mysql ServerDBI Rose
Old Old .15 .3
On 4/20/07, James Masters <[EMAIL PROTECTED]> wrote:
> I just can't imagine what's going on here. Thanks for any pointers,
Have you tried running the modules on the old machine but pointing
them to the MySQL db on the new machine? That might help narrow it
down...
-John
---
On 4/19/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
> Would it be terribly difficult to port:
>
> Rose::DB::Object::MixIn
>
> into
>
> Rose::Object::MixIn
>
> and then just having Rose::DB::Object::MixIn be a subclass of
> Rose::Object::MixIn for compatibility
Sure, seems reaso
On 4/20/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
> On Thu, Apr 19, 2007 at 04:59:18PM -0400, John Siracusa wrote:
>> The full DBI trace output is included below. I don't see multiple
>> disconnects (or any disconnects, really) in the output, so I'm pretty sure
>> it's only using one $dbh.
>
> I
my guy feeling is that maybe you lost some indexes on db tables
during the migration
i'd do a raw test in a sql client directly, bench query on each and
use 'explain' to see how the planner is attempting the call
-
This
I am utterly baffled by this. Over the last week, I've moved my Apache,
MySQL, CGI server to a new machine.
Old machine = Shuttle AMD Athlon XP 3200+ (400FSB), 1024MB DDR RAM.
New machine = Shuttle G2 3200B SD32G2, E6300 (2x 1.86 GHz) Intel CPU
(Core2 Duo), 2 GB RAM
As hoped for, the new PC whi
On 19 Apr 2007, at 20:31, John Siracusa wrote:
[snip]
> * Use an inside-out object approach.
>
> $My::Data{object_id($self)}{'whatever'} = ...
[snip]
I use Ovid's Class::BuildMethods for this. Lightweight and does the job.
Adrian
-
13 matches
Mail list logo
