t; [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell> Sent: 28 September 2005 14:35> To: Axapta-Knowledge-Village@yahoogroups.com> Subject: RE: [Axapta-Knowledge-Village] To add or not to add an index?> > > so I should make it a normal table you mean is it harry?> Thanks> James
Barry
Sent: 28 September 2005 16:18
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: RE: [Axapta-Knowledge-Village] To add or not to add an index?
James,
One possible way to determine the best solution is to run a test script and
time the process. You might try the combinations
(500,000)...
>
> thanks again
> James
>
>
> -Original Message-
> From: Axapta-Knowledge-Village@yahoogroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of James Flavell
> Sent: 28 September 2005 14:35
> To: Axapta-Knowledge-Village@yahoogroups.com
> Subject: R
Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowledge-Village] To add or not to add an index?
so I should make it a normal table you mean is it harry?
Thanks
James
-Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of
James,
One possible way to determine the best solution is to run a test script
and time the process. You might try the combinations
1. Temporary table with unique index
2. Permanent table with unique index
3. Temporary table with an index and in code check for
duplicates
PROTECTED] On Behalf Of James
FlavellSent: 28 September 2005 14:35To:
Axapta-Knowledge-Village@yahoogroups.comSubject: RE:
[Axapta-Knowledge-Village] To add or not to add an index?
so I
should make it a normal table you mean is it harry?
Thanks
James
-Original
-Knowledge-Village@yahoogroups.comSubject: Re:
[Axapta-Knowledge-Village] To add or not to add an index?
hi James
I think that with 50,000 records the database search will be lot faster
than searching the temp table.
regards
harryJames Flavell <[EMAIL PROTECTED]>
wrote
hi James
I think that with 50,000 records the database search will be lot faster than searching the temp table.
regards
harryJames Flavell <[EMAIL PROTECTED]> wrote:
Hi I have an import script that is inserting/updating info to an Axapta temptable that has about 7 fields in it.In my import
8 matches
Mail list logo