Updating records while importing

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

Запомнить меня

Забыли пароль?

Добавить ответ Показать ответы (39)

Решено Updating records while importing

[How] is it possible to just update existing records while using vCursor.importText()?

Комментарий

There are no comments made yet.

Ответы (39)

Christian Breu Ответ принят

Can you please update the samples too?
I could not get it to work with 9.1.5

Комментарий

There are no comments made yet.

Ivan Smahin Ответ принят

It should work for "MATCHED" actions as you wrote above ("NOT MATCHED" actions are still not supported for such a complex conditions).

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Thank you Ivan.
If possible, please extend it to be without limitations.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

The problem is, like that it is not possible to insert a record (when not matched by target).
But this was the main requirement...

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Thank you Ivan.
If possible, eliminate the limitations.
Like that, I cannot insert a record (WHERE NOT MATCHED BY TARGET) and this is a core requirement!

Комментарий

There are no comments made yet.

Sergey Pashkov Ответ принят

Hello Christian,

Unfortunately, this task requires much more time than we planned.

How big are the table and CSV file?
Is it necessary to merge them regularly?

We continue to work on improving MERGE, but maybe a stored procedure can be used for it?

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Hi Sergey

~ 3 Mio records to merge daily.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Hi Ivan

Thank you for that good news – I am going to check it out!

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Can you tell me more about the release date of v9.2?

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Great – thank you Sergey.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Seems to be very unstable – VStudio is crashing even I just edit text of a query...

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Yep, VStudio is crashing without a reason – just editing text in the sql-editor.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Ok, looks like a problem with VStudio 9.2 – when I use VStudio 9.1.5 it works.

Комментарий

There are no comments made yet.

Sergey Pashkov Ответ принят

Hi Christian,

It looks like this crash in SQL Ident Resolver, you can disable it using "A" button in the top right corner above the editing area.
What kind of query was it?

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Hi Sergey

This does. not help – the application just crashes after some seconds – without action at all.
There was just text from MERGE testing from last versions.

The "A"-button is also active in v 9.1.5 without problem.

I sent you some crash reports yesterday.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

MERGE command seems to work now as expected.
Tested with VServer 9.2 on Mac OS and VStudio Pro 9.1.5 on Mac OS but just with some records.
Merge with ~4 million records could not be tested – seems it ist too much for my Testserver on a Mac Mini.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

How long should it take to just delete 4 million records (DELETE FROM Table)?
Seems anything is not ok here waiting and waiting but nothing happens.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

Trying MERGE with 10000 records...
Thought it should be damn fast but it is damn slow.

Комментарий

There are no comments made yet.

Christian Breu Ответ принят

What can make the VServer faster – more ram, more processor cores?
What would be a good configuration?

Комментарий

There are no comments made yet.

Страница :
1
2

There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Чтобы оставить ответ, необходимо зарегистрироваться

Вы должны быть зарегистрированы, чтобы иметь возможность оставить ответ. Водите, используя форму входа или зарегистрируйтесь, если вы впервые на сайте. Зарегистрируйтесь здесь »

Забыли пароль?

Решено Updating records while importing

Categories

Продукты

Поддержка

О Компании