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:
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.
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.
