Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Error Message - 'Poor performing query - too many rows examined' — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Accepted answer
edited Jun 8, 2022 12:02PM in General Technical Discussions 5 comments


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";
        $impactedAddress = new RNCPHP\Geo\Incident();
        $impactedAddress->ImpactedAddress = $address->ID;

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!