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

Tue, 27 Sep 2005 23:43:14 -0700

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



Reply via email to