Error Message - 'Poor performing query - too many rows examined'

Content

Hi all,

I have written a custom script to import an excel file. I am trying to do the following:

Use 'importArray[1]' as a unique reference to read the appropriate Custom Object 'Geo$Address' record and retrieve Geo$Address.ID. Set ImpactedAddress to Geo$Address.ID. Code is the following:

        $cndb_ar_id = RNCPHP\ROQL::escapeString($importArray[1]);
        $address = RNCPHP\Geo\Address::first("CNDB_AR_ID = $cndb_ar_id");
        if (!$address) {
        echo "Error: No such Address where CNDB_AR_ID = $cndb_ar_id. Skipping to next row.\n";
        continue;
        }
        $impactedAddress = new RNCPHP\Geo\Incident();
        $impactedAddress->ImpactedAddress = $address->ID;
        $address->save();