Finance | Project Operations, Human Resources, ...

not responding when i query about this table

(0) Share

Report

Posted on by mohammed.mqi

2,046

Greeting everyone

when i try to get query of this table DimensionAttributeValueCombination

static void Job24(Args _args)
{
    DimensionAttributeValueCombination   dimensionAttributeValueCombination;

    while select * from dimensionAttributeValueCombination 
    {
        info(strFmt("%1",dimensionAttributeValueCombination.DisplayValue));
    }
}

it's not responding

this table doesn't have customization

also i did deleted and sync that table but still make ax2012 not responding for ever

also i try to add parameter even that make it not responding for ever too

All responses (2)

Answers (0)

Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: not responding when i query about this table

What exactly are you trying to achieve? Clearly this is just a job to list all DisplayValues but what is your business requirement?

I think the slowest thing in your code is that you try to print so many entries to the infolog.
Suggested answer

Martin Dráb 232,988 Most Valuable Professional on at

Like (0)

Report

RE: not responding when i query about this table

This table usually has many records, therefore iterating all of them may take a while. Especially when you run code on client - consider doing it on server.

Also, you fetch all fields from database and then ignore all of them except of DisplayValue. Selecting just DisplayValue will improve performance.