1. Christian Breu
  2. as Valentina DB Server
  3. Mittwoch, März 27 2019, 11:08 PM
  4.  Abonnieren via E-Mail
[How] is it possible to just update existing records while using vCursor.importText()?
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
What can make the VServer faster – more ram, more processor cores?
What would be a good configuration?
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Trying MERGE with 10000 records...
Thought it should be damn fast but it is damn slow. :(
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
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. :(
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Anhänge
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Ok, looks like a problem with VStudio 9.2 – when I use VStudio 9.1.5 it works.
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Yep, VStudio is crashing without a reason – just editing text in the sql-editor. :(
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Seems to be very unstable – VStudio is crashing even I just edit text of a query...
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Great – thank you Sergey.

:)
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Christian,

A new version is available for download.
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Can you tell me more about the release date of v9.2?
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Hi Ivan

Thank you for that good news – I am going to check it out!
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Please check v.9.2 (coming soon) - all kind of merges are supported now.
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Hi Sergey

~ 3 Mio records to merge daily.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
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!
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
The problem is, like that it is not possible to insert a record (when not matched by target).
But this was the main requirement...
Kommentar
There are no comments made yet.
Christian Breu Akzeptierte Antwort
Thank you Ivan.
If possible, please extend it to be without limitations.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
It should work for "MATCHED" actions as you wrote above ("NOT MATCHED" actions are still not supported for such a complex conditions).
Kommentar
There are no comments made yet.
  • Seite :
  • 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