Working with multiple objects of the same type (PHP)

Question

What is the corecte way to handle with al lot objects of the same type?

Example:

When i get a list of notes from the database with zend framework i get a rowset which contains an array with note data.

If the number of notes in the database is 20 records large it's no problem to create a note object for every note in the database. But if the database contains 12.500 note records what shall i do than? Try to create 12.500 objects is possible but it's shure isn't quick enough.

Ty, Mark

This is the code i use.

Code to get the data from the database:

if (is_numeric($id) && $id > 0) {
    $select = $this->getDao()->select();
    $select->where('methode_id = ?', $id);
    $select->order('datum DESC');
    $rowset = $this->getDao()->fetchAll($select);
    if (null != $rowset) {
        $result = $this->createObjectArray($rowset);
    }
}

createObjectArray function:

protected function createObjectArray(Zend_Db_Table_Rowset_Abstract $rowset)
    {
        $result = array();
        foreach ($rowset as $row) {
            $model = new Notes();
            $this->populate($row, $model);
            if (isset($row['id'])) {
                $result[$row['id']] = $model;
            } else {
                $result[] = $model; 
            }
        }//endforeach;
        return $result;
    }

Populate function

private function populate($row, $model)
    {
        // zet de purifier uit om overhead te voorkomen
        if (isset($row['id'])) {
            $model->setId($row['id']);
        }
        if (isset($row['type'])) {
            $model->setType($row['type']);
        }
        if (isset($row['tekst'])) {
            $model->setLog($row['tekst']);
        }
        if (isset($row['methode_id'])) {
            $model->setSurveyMethodId($row['methode_id']);
        }
        if (isset($row['klant_id'])) {
            $model->setCustomerId($row['klant_id']);
        }
        if (isset($row['gebruiker_aangemaakt_tekst'])) {
            $model->setCreatedByUser($row['gebruiker_aangemaakt_tekst']);
        }
        if (isset($row['gebruiker_gewijzigd_tekst'])) {
            $model->setUpdatedByUser($row['gebruiker_gewijzigd_tekst']);
        }
        if (isset($row['gebruiker_aangemaakt'])) {
            $model->setCreatedByUserId($row['gebruiker_aangemaakt']);
        }
        if (isset($row['gebruiker_gewijzigd'])) {
            $model->setUpdatedByUserId($row['gebruiker_gewijzigd']);
        }
        if (isset($row['datum_aangemaakt'])) {
            $model->setDateCreated($row['datum_aangemaakt']);
        }
        if (isset($row['datum_gewijzigd'])) {
            $model->setDateUpdated($row['datum_gewijzigd']);
        }

        $model->clearMapper();
        return $model;
    }

what are you going to do with that data? some analytics or display it to user? — heximal, Aug 03 '11 at 12:00
With this specific data display it to user but other object could be used for analytics — Mark Eilander, Aug 03 '11 at 12:16

score 0 · Answer 1 · answered Aug 03 '11 at 12:00

0

You could page your requests, so you only get a set amount of notes back each time. Although I can't see a problem with "only 12,500" objects, unless your object creation is doing something costly, i.e more queries on the database etc.

answered Aug 03 '11 at 12:00

Alan Hollis

1,292
3
14
29

I would like to page my request but my boss likes to have all the results on screen even if 80% can't be seen directly – Mark Eilander Aug 03 '11 at 12:17
Have you checked your indexes, do you have an index on methode_id in your table? – Alan Hollis Aug 15 '11 at 10:25

Hari K T · Answer 2 · 2011-08-03T12:58:39.520

I am not so sure about your question. For eg :

//Create a single object
$obj = new NoteObject();

//Set the properties if it differs
$obj->setX( $row );
//Make use of the method
$obj->processMethod();

So this way you just need a single object. Lets see the code if its not to give you a right answer.

Edit :

What I thought was in

protected function createObjectArray(Zend_Db_Table_Rowset_Abstract $rowset)
{
    $result = array();
    //Create the model here
    $model = new Notes();
    foreach ($rowset as $row) {
        //Yes populate the values
        $this->populate($row, $model);
        /*
        And not like saving the object here in array
        if (isset($row['id'])) {
            $result[$row['id']] = $model;
        } else {
            $result[] = $model; 
        }*/
        //Do some calculations and return the result in array
        $result[$row['id']] = $this->doSomething();
    }//endforeach;
    return $result;
}

I am not sure why you are keeping this object there itself. Any reuse ? the probably paginate and do :-)

I added some code i use to fill the objects. I don't quite onderstand the single object example. — Mark Eilander, Aug 03 '11 at 12:25

Working with multiple objects of the same type (PHP)

2 Answers2