Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (39)

Resolved Updating records while importing

  1. Christian Breu
    Christian Breu
  2. as Valentina DB Server
  3. Wednesday, March 27 2019, 11:08 PM
  4.  Subscribe via email
[How] is it possible to just update existing records while using vCursor.importText()?
Comment
There are no comments made yet.
Responses (39)
Christian Breu
Christian Breu Accepted Answer
What can make the VServer faster – more ram, more processor cores?
What would be a good configuration?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 1
Christian Breu
Christian Breu Accepted Answer
Trying MERGE with 10000 records...
Thought it should be damn fast but it is damn slow. :(
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 2
Christian Breu
Christian Breu Accepted Answer
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. :(
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 3
Christian Breu
Christian Breu Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 4
Christian Breu
Christian Breu Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 5
Sergey Pashkov
Sergey Pashkov Accepted Answer
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?
Attachments (1)
Screenshot 2019-05-29 17.39.44.png Screenshot 2019-05-29 17.39.44.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 6
Christian Breu
Christian Breu Accepted Answer
Ok, looks like a problem with VStudio 9.2 – when I use VStudio 9.1.5 it works.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 7
Christian Breu
Christian Breu Accepted Answer
Yep, VStudio is crashing without a reason – just editing text in the sql-editor. :(
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 8
Christian Breu
Christian Breu Accepted Answer
Seems to be very unstable – VStudio is crashing even I just edit text of a query...
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 9
Christian Breu
Christian Breu Accepted Answer
Great – thank you Sergey.

:)
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 10
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Christian,

A new version is available for download.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 11
Christian Breu
Christian Breu Accepted Answer
Can you tell me more about the release date of v9.2?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 12
Christian Breu
Christian Breu Accepted Answer
Hi Ivan

Thank you for that good news – I am going to check it out!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 13
Ivan Smahin
Ivan Smahin Accepted Answer
Please check v.9.2 (coming soon) - all kind of merges are supported now.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 14
Christian Breu
Christian Breu Accepted Answer
Hi Sergey

~ 3 Mio records to merge daily.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 15
Sergey Pashkov
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 16
Christian Breu
Christian Breu Accepted Answer
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!
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 17
Christian Breu
Christian Breu Accepted Answer
The problem is, like that it is not possible to insert a record (when not matched by target).
But this was the main requirement...
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 18
Christian Breu
Christian Breu Accepted Answer
Thank you Ivan.
If possible, please extend it to be without limitations.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 19
Ivan Smahin
Ivan Smahin Accepted Answer
It should work for "MATCHED" actions as you wrote above ("NOT MATCHED" actions are still not supported for such a complex conditions).
Comment
There are no comments made yet.
  1. more than a month ago
  2. as Valentina DB Server
  3. # 20
  • Page :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories