Thanks to the list for tips. I can't say the process is running that
much faster (its just a lot of data to sling around) but postgres can
now handle multiple processes at once so I'm seeing a definite speed
up with multiple jobs running.
However, I'm still seeing something interesting, as
On Tue, Feb 02, 2010 at 11:14:27AM -0800, James Marca wrote:
Hi.
First DBIx::Class is excellent and kudos all around.
...
My query is rather large and expensive. I'm using paging not to drive
a UI, but because when running the request without paging psql
complained that it ran out
On Wed, Feb 03, 2010 at 10:40:12AM -0800, Ihnen, David wrote:
It takes four hours to run the query? I have written queries
affecting grouping and sorting 6 billion rows that ran several
orders of magnitude faster than that.
Well, I'm pretty good at writing sql queries, but I've never claimed
On Wed, Feb 03, 2010 at 10:50:10PM +0100, Peter Rabbitson wrote:
James Marca wrote:
The only thing that can be prepare_cached are parametrized queries
(where the query stays the same and only the bindvalues for ? change).
Limits are currently not expressed via ?'s and it is rather hard
On Wed, Feb 03, 2010 at 02:14:35PM -0800, Ihnen, David wrote:
Based on what you've said (5 minute summaries) I would expect your records
have a date field that you are grouping in your query.
My strategy for handling summarizing this type of data would
probably be something on the order of
On Wed, Feb 03, 2010 at 11:14:28PM +0100, demerphq wrote:
On 2 February 2010 20:58, James Marca jma...@translab.its.uci.edu wrote:
On Tue, Feb 02, 2010 at 11:14:27AM -0800, James Marca wrote:
Hi.
First DBIx::Class is excellent and kudos all around.
I have recently needed to use
to optimize as much as I can in my
somewhat extreme situation?
Thanks,
James Marca
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo
On Tue, Feb 02, 2010 at 11:14:27AM -0800, James Marca wrote:
Hi.
First DBIx::Class is excellent and kudos all around.
I have recently needed to use the paging feature for the first time
and I'm not sure of the best way to do this.
First a simple question: How should one terminate
On Tue, Oct 21, 2008 at 09:05:52AM +0100, Howe, Tom (IT) wrote:
I'm not sure if this works but I would try something like...
join = [ { cds=ripped }, { cds=ripped } ]
Ha! Awesome advice. I guess in my late-night hacking I didn't try
that combination.
To sum up problem and solution,
Hi all,
I want to get two different values from nested join tables. Borrowing
from the excellent Cookbook examples:
If the same join is supplied twice, it will be aliased to rel_2 (and
similarly for a third time). For e.g.
my $rs = $schema-resultset('Artist')-search({
'cds.title'
10 matches
Mail list logo