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

hi following help is from the developers guide. The one where you save time is "Records are only inserted when the kernel finds the time appropriate, but no later than the call to insertDatabase." regards harry RecordInsertList RecordInsertList may be considered an alternative to

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 I have an import script that is inserting/updating info to an Axapta temptable that has about 7 fields in it.In my import

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

Title: Message 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 Harry (Harshawardhan DeshpandeSent: 28 September 2005 15:24To:

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

Title: Message sorry forgot, and add index as well? wondering is the overhead on inserts (50,000)going to outweigh the read performance of an index (500,000)... thanks again James -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL

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 1. Temporary table with unique index 2. Permanent table with unique index 3. Temporary table with an index and in code check for

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

hi yes, a normal table, thats what I meant. I think you should add an index as well but not sure. You should however use record insert list, this will certainly speed up the performance. regards harryJames Flavell [EMAIL PROTECTED] wrote: sorry forgot, and add index as well? wondering

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

thanks harry, I will see what can be done (it is existing code that I dont want to change too much but I guess turning of TMP property is not going to cause problems) Sorry not being a programmer I have no idea what record insert list iscan point me in the right direction. Thanks for

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

Hi Barry, I would love to try also but I don't think I have time right now as this is well overdue but will try to and let everyone know if manage to Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bayliss, Barry

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

Hi I have an import script that is inserting/updating info to an Axapta temp table that has about 7 fields in it. In my import script I need to go into this temp table to check if a record already exists based on three of the fields that are being imported (i.e. checking what I am importing