1. Christian Breu
  2. as Valentina DB Server
  3. 水, 3月 27 2019, 11:08 PM
  4.  メールで購読
[How] is it possible to just update existing records while using vCursor.importText()?
コメント
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.
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 承諾済みの回答
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 承諾済みの回答
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 承諾済みの回答
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.
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 承諾済みの回答
Ok, looks like a problem with VStudio 9.2 – when I use VStudio 9.1.5 it works.
コメント
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 承諾済みの回答
Seems to be very unstable – VStudio is crashing even I just edit text of a query...
コメント
There are no comments made yet.
Christian Breu 承諾済みの回答
Great – thank you Sergey.

:)
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Christian,

A new version is available for download.
コメント
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 承諾済みの回答
Hi Ivan

Thank you for that good news – I am going to check it out!
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Please check v.9.2 (coming soon) - all kind of merges are supported now.
コメント
There are no comments made yet.
Christian Breu 承諾済みの回答
Hi Sergey

~ 3 Mio records to merge daily.
コメント
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 承諾済みの回答
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.
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, please extend it to be without limitations.
コメント
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.
  • ページ :
  • 1
  • 2


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories