InaPlex Forums

Hi,

 Sorry for my english, i'am french.

i meet a problem. i use Inaport for import data from file.csv to  Sql server 2000 for sage CRM table pricing.

I have 12000 lines had updating and Inaport takes exactly 2mn and 10 second for updating one tuple.

I am very annoy, i don't know if it comes from Inaport or Sql server.

 Have you an solution for me, thanks

Hi

No need to apologise - your English is much better than my French.

That does seem a very long time to update a record. Some questions:

1. How large is the pricing table?
2. Can you provide a screen shot of your match criteria on the table?

You might want to consider SQL Matching, which is an alternative technique offered by Inaport than can be much faster on large tables. For information, see the topic "Matching Techniques" here:

http://www.inaplex.com/Resources/Tutorials.aspx

Regards

Admin

Hi,

Thanks for your answer,

I have solved my problem in creating à new field in table which result  of concantate  all index field.

Under inaplex i had only now one field for match againt seven field before.

 regards,

 Stephix.

Hi Stephix

Pleased you solved it. Did you have a look at the SQL matching tutorial?

Regards

Admin

Hi,

 I have seen the sql matching tutorial but i have tried and the  problem persisted.

 Sorry.