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 is....can point me in the right direction. Thanks for all your help James Quoting "Harry (Harshawardhan Deshpande" <[EMAIL PROTECTED]>: > 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 > > harry > > James Flavell <[EMAIL PROTECTED]> wrote: > 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 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 > > -----Original Message----- > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Harry > (Harshawardhan Deshpande > Sent: 28 September 2005 15:24 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: 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 > > harry > > James Flavell <[EMAIL PROTECTED]> wrote: > 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 whetehr it has been imported before etc). > > I am wondering is it worth while to put a unqiue index on this table for > these 3 fields or not? > > I am expecting maybe to have 50,000 records in this temp table every time I > run the import script and will need to search it maybe 500,000 times during > the import.... > > If there is no index will SQL do some 'optimization' so the performance > difference is minimal? (I mean the number of fields on the table is not that > many more than the index and I am wondering given the small size of the > record SQL will cache or keep all the records in memory - although since it > is a TMP table I am not sure will any of this be stored in the SQL or on the > client - should I cahnge from TMP to normal table???) > > Appreaciate some advice so as to speed up this import > Thanks > James > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > > Sharing the knowledge on Axapta. > > > > SPONSORED LINKS > Business finance course Business to business finance Small business finance > Business finance consultant Business finance magazine Business finance uk > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "Axapta-Knowledge-Village" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > --------------------------------- > Yahoo! for Good > Click here to donate to the Hurricane Katrina relief effort. ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/