Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Perl Monks User Search

( #6364=superdoc: print w/replies, xml ) Need Help??

This is where you can search for all the writeups contributed by any user. Just enter the user name and select the order for the search.

Author: Show nodes
Order by: starting at .
Node Type: Show Categorized Q&A (Why?)

Or try a Super Search

These nodes all have stuff by jonadab (showing 101-150 out of ~1136?):

Previous 50 Next 50
Node ID Writeup Created
711964 Re: Counting events and getting top 5 matches 2008-09-17 11:37
711961 Re: Counting events and getting top 5 matches 2008-09-17 11:14
711954 Re: how to put values into $$rhash_params{'import_file'}->filename? 2008-09-17 10:32
711951 Re: Specific substitution in regular expressions 2008-09-17 10:20
688271 Re: Periodic Save As 2008-05-24 11:04
686908 Periodic Save As 2008-05-16 12:53
686810 I just keep them wherever. 2008-05-15 20:54
684175 Re: Which came first? 2008-05-02 14:15
682805 Re: Converting datetime formats 2008-04-25 12:33
682798 Re: How to Read local CDROM content from web page 2008-04-25 12:02
669016 Re: Consideration for obscenity 2008-02-20 14:08
664405 Re: Which HTML form builder 2008-01-26 00:54
660646 Re: IE Automation with Update Panel 2008-01-06 10:38
660525 Re: Name Space 2008-01-05 09:38
640578 Re: You've just spilled something on your tie at lunch... Do you: 2007-09-23 11:39
629387 Re: When it comes to dancing, 2007-07-29 10:33
628108 Re: My computer's last downtime was due to... 2007-07-22 12:28
622776 Re: I mostly learned to cook from: 2007-06-22 12:21
616995 Re: No longer a programmer 2007-05-23 12:45
616743 Re: Since I discovered Perl, I've given up: 2007-05-22 12:21
612587 Re: Pause Loop 2007-04-28 19:48
612584 Re: Non-programmers and variable scope 2007-04-28 18:18
612560 Re: help using packForget() 2007-04-28 15:36
612555 Re: Die statement with text & formatting of the user 2007-04-28 15:08
612552 Re: Perl 6 and external libraries 2007-04-28 14:25
611890 Re: Socks with Sandals: 2007-04-25 01:03
611878 Re: Socks with Sandals: 2007-04-24 23:17
611693 Re: Socks with Sandals: 2007-04-24 11:09
610179 Re: Read from file to two arrays. 2007-04-15 12:04
608755 Re: Formatting The Communist Manifesto 2007-04-06 20:37
608751 Re: calling a perl file from a perl script 2007-04-06 20:22
608741 Re: calling a perl file from a perl script 2007-04-06 20:03
608736 Re: calling a perl file from a perl script 2007-04-06 19:45
608635 Re: Converting epoch times after 2038 2007-04-06 10:43
608441 Re: Converting epoch times after 2038 2007-04-05 10:28
608440 Re: Converting epoch times after 2038 2007-04-05 10:21
606408 Re: I read blogs / web journals... 2007-03-24 12:42
604959 Re: Sorting a text file 2007-03-15 10:48
604888 Re: MySQL and perl? Or something else? 2007-03-14 20:43
604817 Re: Installing module 2007-03-14 14:13
604812 Re: I wish YouTube had not removed: 2007-03-14 13:54
604433 Re: Installing module 2007-03-12 21:33
604241 Re: How to generate a banner 2007-03-11 17:14
604238 Re: How do I reverse the order of the first and last word of a string? 2007-03-11 16:44
604212 Re: How do I reverse the order of the first and last word of a string? 2007-03-11 11:35
604211 Re: If Perl Existed in the 1960's... 2007-03-11 11:18
603808 Re: IDE for perl 2007-03-08 12:11
603450 Re: Proper monetary rounding 2007-03-06 16:29
603203 Re: Proper monetary rounding 2007-03-05 12:49
603199 Re: Preventing malicious T-SQL injection attacks 2007-03-05 12:35
Previous 50 Next 50
Log In?

What's my password?
Create A New User
[Corion]: erix: Yeah, I just found that it has no documentation at all on how to circumvent/ eliminate "1+n SELECTs" by building a local hash... I guess I have to make ->has_many do the hash lookup instead of doing the SQL query. But as the problem ...
[Corion]: ... has only manifested itself so far through the puzzled questions of other bystanders, I won't go deeper at this time. But the DBIx::Class documentation could well do with a document on how to make "it" (that is, ORMs in general) faster ;)
[Corion]: I find that DBIx::Class, like most ORMs makes things easy until they become performance critical and then makes it horribly hard to change things because the design is highly inflexible if you don't already know about the problems of 1+n :-/
[choroba]: that's why I don't like similar libraries. They pretend you don't have to learn SQL, but in the end, you have to learn how SQL plus to overcome their own limitations
[Corion]: "Just write the proper SQL beforehand" is of course the appropriate solution, but if you did that, you wouldn't/couldn't use DBIx::Class either. At least not in an obvious (to me) way.
choroba scratches a "how"
[Corion]: choroba: Exactly... But maybe that's just because I'm old and grumpy ;)
[Corion]: But maybe that could also be a nice talk, how to restructure your DBIx::Class-based app to remove 1+n-style query patterns
[Corion]: In theory, that should be easy because you should have the "where" clause from part 1 of the patterns and then do the corresponding single select using that where clause to select all rows in one go for the n other parts.
[Corion]: But in practice I don't see any obvious places documented in DBIx::Class where one would do that and then just feed hash lookups instead of DB lookups for ->has_many results

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2017-09-25 11:11 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (279 votes). Check out past polls.