-
Kim Lombard
- PowerBuilder
- Saturday, 29 March 2025 06:34 PM UTC
I've identified the "slowness" issue related to my migrated PB22 app. It's in the volume of data on our PRODUCTION server, which I didn't have access to until this week. I'm looking into archiving data and a general cleanup. Before I do that I want to fully migrate the app to PFC 22.
Once I do that I will provide some timings (pb10, pb22 before clean up, pb22 after clean up) and maybe some sample code and my solution(s).
I wrote a single window app and PB 22 and was able to for the first time see the "real" problem in PROD. The DEV server has < 10 percent of the data which has to be masked because of Hippa regulations. So in-other-words: "I was barking up the wrong tree", and hence my enormous frustration. I hope I didn't take it out on anyone in this forum.
I've been given more time to "do it right". I recommended to take Chris Pollachs' advice and migrate from PFC 99 --> PFC 22> thank you for your detailed answer, Chris.
My company has bought off on me making this work for us for "a couple of years". I wrote a justification and a project plan which were accepted and I'm opening Jira's for the work.
I want to especially thank John Fauss and David Peace. The support and assistance they both provide is part of the work justification and project plan is was able to supply management with last week. I feel like I owe you, David, some compensation for you time and effort.
thank you,
Kim
--------
Any advice as to which .PBLs I should use instead of my "old" tv_1, nvuo_transaction would be gratefully accepted.
I'm thinking of just replace things like "nvuo_transaction.of_begintransaction"
with code to call the function in pfcapsrv.pbl --- n_tr.of_Begin
This is what PB 10 app looks like:
Case_Edit WorkSpace
Case_edit target
Case_edit .PBL
d_*
ddw_*
r_*
m_*
p_* (lots of pipe to promote dev-->QA-->prod
n_* with:
n_ds
nvuo_items
nvuo_transaction
w_*
PCF has this copyright in the open event of pfc_w_pagesetup
//////////////////////////////////////////////////////////////////////////////////////////
//
// Event: Open
//
// Description: Initialize window based on pagesetup structure passed in
//
//////////////////////////////////////////////////////////////////////////////////////////
//
// Revision History
//
// Version
// 5.0 Initial version
//
//////////////////////////////////////////////////////////////////////////////////////////
//
// Copyright © 1996-1997 Sybase, Inc. and its subsidiaries. All rights reserved.
// Any distribution of the PowerBuilder Foundation Classes (PFC)
// source code by other than Sybase, Inc. and its subsidiaries is prohibited.
//
//////////////////////////////////////////////////////////////////////////////////////////
pfc.pbl
d_printtree
f_setplatform
n_cst_baseattrib
n_cst_conversion
n_cst_dssrv
n_cst_infoattrib
n_cst_platform
n_cst_platformwin32
n_cst_string
n_cst_tvattrib
n_cst_zoomattrib
pfc_n_cst_baseattrib
pfc_n_cst_conversion
pfc_n_cst_dberrorattrib
pfc_n_cst_dssrv
pfc_n_cst_dssrv_multitable
pfc_n_cst_dssrv_multitableattrib
pfc_n_cst_dssrv_printpreview
pfc_n_cst_dssrv_report
pfc_n_cst_dwobjectattrib
pfc_n_cst_infoattrib
pfc_n_cst_numerical
pfc_n_cst_platform
pfc_n_cst_platformwin32
pfc_n_cst_string
pfc_n_cst_tvattrib
pfc_n_cst_zoomattrib
pfc_n_ds
pfc_u_rb
pfc_u_st
pfc_u_tv
u_rb
u_st
pfc_w_pagesetup
pfc_w_response
w_pagesetup
w_response
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.