Forum Replies Created

  • jattwick

    Member
    August 24, 2023 at 12:00 am in reply to: Partition Table Memory Usage

    Thank you! Another related question – after doing the initial query on the partition, when I do

    100#rawData

    That still worked (and was fast, and did not increase the memory usage). If you’re saying we are not actually loading the partition into memory, shouldn’t this not work? Is there a way to partially load the columns in the partition?

  • jattwick

    Member
    July 12, 2023 at 12:00 am in reply to: Constrained Curve Fitting in KDB

    Thank you  ! the lsq won’t fit our use case since we want the coefficients to be strictly greater than zero.

    We’ll have a look at embedPy – was just hoping somebody had possibly written a native kdb implementation already.

  • jattwick

    Member
    May 25, 2023 at 12:00 am in reply to: Amend Entire Works in memory but not with a handle?

    The weird thing for me is we have a process that writes in this fashion, running several times a day. In some cases, it fails (which makes sense given the explanation you have given), but it does work in some cases as well. might lean towards just re-architecting the datatypes for this table.

  • jattwick

    Member
    April 27, 2023 at 12:00 am in reply to: Sym File Locking

    What precisely does at a process level mean? Does that mean only if a single port is multithreading (i.e. peaching and writing to the sym file the lock will be used)? Or I have two distinct ports both writing to the sym file, this built in locking won’t work?
    My hypothesis is in the latter (multiple ports writing to the sym file at once), there is no locking of the sym file and we are seeing some concurrent writes. Solution for us to write our own lock that can handle these cases.