Recent content by PatrickTingen

Haha, every now and then its good to have a reality check. That was your 1st point on the list. Our db server indeed has enough memory to keep the complete db in memory. Our buffer hit ratio is constantly 100%, no matter what we do. Even during our data purge where we read the oldest records, we...

I didn't even know the -csoutput flag existed at all, let alone that is supported in 11.7 :) I know, I have some scripts lying around that I created back in 2003 to replicate a database purely based on AI extents. It's not that hard to do and I mentioned it more than once, but "not needed"...

Yes, see attached zip

What we want to improve is "performance". Now since that is a wide term, we are not facing an actual problem, at least not that we know, but I am just wondering whether our configuration could be much better than what it is now. If we could speed up the application that would benefit our users...

Thanks for all of your feedback. Today we ran the data purge during normal business hours. Because: why not, yolo! Our db server did not give a single f**k and users did not even notice the purge was running at all. Yes, the RPB column is the theoretical # records/block We might still do that...

We are in the middle of a clean-up of old data in our database, deleting approximately 25-30% of the contents. I ran a tabanalys on the db and noticed that more than half of the tables have very small records, thus not filling up our 8k blocks. Here is a screenshot of some of our offenders...

Also posted this on the Progress Discord server, so perhaps you already read it... Do you like coding? And a little challenge? And a little fun? If three times a yes, then Advent of Code is something for you. What is it In their own words: "Advent of Code is an Advent calendar of small...

But wait, there is another possibility. Perhaps even dirtier than the previous. If the field ShippingMethod is not mandatory (check it in that wonderful tool DataDigger :cool:), you could assign it the unknown value. Progress allows duplicate records when one or more of the fields in a unique...

No. This is impossible with your current index. Your index dictates that the combination of ShippingMethod and ConsignmentNumber must be unique. You state that the ShippingMethod is left blank in all cases, so that basically sets you back to the ConsignmentNumber to be the only unique value...

A lot of the spam seems to come from user "Gacor", can't you just kick him/her out?

According to your screenshot there is only one unique index on your table, consisting of two fields: ShippingMethod and ConsignmentNumber. Yet, your FIND FIRST searches for a record with 3 fields: ArEntity, OrderNumber and ConsignmentNumber. There is your problem. Your unique index consists of...

That should be enough, but I don't have a v9 on my laptop to test it. You could also try to open datadigger.p in the editor and press F2 and see what it does. More info on the classroom edition can be found here

Interesting tool, did not know it, but I like it already :) On topic: wouldn't it be simpler to put an image on the button with a 2-line label?

To have a better environment, you could download and install the classroom edition and do some work from there. And to support exploring the database, you could try to use an old version of the DataDigger to see what's in the database and quickly browse through it. I am not sure if it will...

Since we have some old shit programs based on ADM-1, could you make the docs available for me? Would be of help when debugging some of this old stuff