Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved PB and memory-optimized tables

  1. How-to
0
Votes
Undo
  1. Menna Pablo Javier
    Menna Pablo Javier
  2. PowerBuilder
  3. Wednesday, 14 December 2022 13:20 PM UTC

Hi!

I would like to know if anyone has worked on SQL Server with memory-optimized tables in Powerbuilder. Is this possible?

Thanks.

Cheers

Download demo database V2022
Sign an enveloped xml with client digital certific...
Responses (1)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 14 December 2022 16:30 PM UTC
  2. PowerBuilder
  3. # 1

Maybe this will help:
    https://learn.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/introduction-to-memory-optimized-tables

Comment
Load more comments
mike S
  1. mike S
  2. Wednesday, 14 December 2022 18:27 PM UTC
Chris is correct. Its like adding an index to table - things just run faster and PB had nothing to do with it
  1. Helpful 2
Menna Pablo Javier
  1. Menna Pablo Javier
  2. Thursday, 15 December 2022 11:13 AM UTC
Hi.

Thank you for your answers.

I already created some tables of this type and I accessed correctly from PB using embedded SQL.

But I have a problem when working with datastore.

For example, ds.InsertRow or ds.Update give me an error:



Error 41332 - SQLSTATE = 42000

Memory-optimized tables and natively compiled modules cannot be created or accessed when session TRANSACTION ISOLATION LEVEL is set to SNAPSHOT.



Again, thanks for your time.

Regards
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 15 December 2022 13:49 PM UTC
Have you tried changing your DB isolation level as the error message is implying?
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


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