Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re^3: Good code or good templates (Maypole)

by autarch (Hermit)
on Mar 27, 2005 at 15:15 UTC ( #442627=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Good code or good templates (Maypole)
in thread Good code or good templates (Maypole)

I remember, all the data is fetched first from the database and only then the items for the current page are filtered. So if you have in your database hundreds of thousends of records you'll have all of them in the memory in one huge array only to filter then a few of them.

This is a problem with Class::DBI, not Maypole. Class::DBI::Iterator fetches all the data and stores it as an array, as opposed to wrapping the underlying DBI statement handle.


Comment on Re^3: Good code or good templates (Maypole)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://442627]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2014-09-21 18:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (173 votes), past polls