> I have a big delay (5 min) when doing a select on InventTrans. It
> happens at line 55 of MarkupAdjustment.adjustInvoice().
>
> Here's the line:
> inventTrans.inventTransId == vendInvoiceTrans.inventTransId
> && inventTrans.dateFinancial == vendInvoiceTrans.InventDate
> && inventTrans.invoiceId == vendInvoiceTrans.invoiceId
> && inventTrans.statusReceipt == StatusReceipt::Purchased
> && inventTrans.statusIssue == StatusIssue::None
> && inventTrans.packingSlipReturned == 0
> && ! inventAdjustAllocate.isAllocated(){
> ...
> }
>
I suppose that if "inventAdjustAllocate.isAllocated()" is in the where
clause the query can not be execute entirely on the SQL server, so for every
record returned the kernel/application have to evaluate the result of the
execution of the method above.
After the first execution the record are in cache and so the time for the
execution decrease.
If this is really the problem, create an index is not necessary because the
problem is not on the database
--
Roberto Ukmar
Indis S.p.A.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
