The next Quebec PUG Meeting will be held in Montreal on Nov 29, 2018. We are fortunate to have both Mike Furgal and Peter Judge making the drive north to share their knowledge on indexes in the Progress database and 4GL.

If you are already a member of the GUPQ, attendance is free but an RSVP is mandatory. If you are not a member of the GUPQ, you are welcome to become a member for $50 CAD / year and join us in Montreal. Sorry, no remote access will be available.

Mike will be diving in to DB internals, explaining how indexes are stored in the database and what you need to do to maintain them.

Peter and I will be presenting our "4GL Code Performance Workshop Take 3: You don't know *beep* about Indexes!".  This 3+ hour hands-on workshop will teach you things you never knew about how the 4GL selects indexes when parsing queries.

RSVP to pk@wss.com please. 

Index Internals Part 1

Part 1 of a 2-part series on how the OpenEdge Database Index Manager works. This first part will cover the internal structures of the indexes, b-trees, key storage, and compression. This will also show you why you need to care about these structures and what tooling there is available to report and manage these structures.

 4GL Code Performance Workshop Take 3: You don't know *beep* about Indexes!
After 25 years in the Progress world, numerous workshops, training courses and presentations, Peter and I can say with some confidence that most programmers don't know the first thing about index bracketing. Ok, maybe they know the first thing, but the second and third thing...unlikely. Four they dost not know, unless maybe they knowest two and three. Five is right out. 

We will awe and inspire you during this 3 hour, hands-on, blow-your-mind, index bracketing workshop. You'll learn about the differences between database queries versus temp-table queries. You'll partake in the explanation of the parsing of those pesky parentheses.  And the mysteries of and and or, or is it or and and, will be de-mystified. You will shake your head, raise your fist, tell us we're wrong, maybe even cry a bit, but at the end of it all, your soul will be cleansed and you'll be a master of all things index-y.