RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-29 Thread Harry \(Harshawardhan Deshpande
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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread James Flavell
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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread djf
(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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread Harry \(Harshawardhan Deshpande
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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-28 Thread Bayliss, Barry
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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-27 Thread James Flavell
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

RE: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-27 Thread James Flavell
-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

Re: [Axapta-Knowledge-Village] To add or not to add an index?

2005-09-27 Thread Harry \(Harshawardhan Deshpande
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