1. Christian Breu
  2. as Valentina DB Server
  3. Среда, Март 27 2019, 11:08 PM
  4.  Подписаться через email
[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