Did you get anywhere with this? Is it possible to get some extended event monitoring set up on the database?
- ProIV Resource Centre
- → Viewing Profile: Posts: Chris Mackenzie
Community Stats
- Group Members
- Active Posts 372
- Profile Views 8,853
- Member Title ProIV Guru
- Age Age Unknown
- Birthday Birthday Unknown
-
Gender
Male
-
Location
Bristol, United Kingdom
Previous Fields
-
First Name
Chris
-
Surname
MacKenzie
-
Nationality
Scottish
-
Year Started ProIV
1989
-
Highest ProIV Version Used
7.0
-
Company Working For
Northgate
-
Companies Worked For
Northgate
PRO-IV,
MSA Focus,
CSC (UK,SOUTH AFRICA,SWEDEN),
MDIS,
Softcare,
Fraser Williams
User Tools
Friends
Chris Mackenzie hasn't added any friends yet.
Latest Visitors
Posts I've Made
In Topic: Fluctuating Process Speed V10.503 With SQL Server 2019
22 February 2023 - 05:22 PM
In Topic: ProIV migration/upgrade
22 February 2018 - 01:21 PM
It is relatively easy to upgrade but there will be problems and you would be well advised to hire an experienced consultant. There may be several steps - you can't go direct from v4 to v8 - there was a major restructure with v5
In Topic: Function keys not working
12 February 2018 - 12:26 PM
Old post but anyway..Long time since i had to do this but you need to check the terminal type in use and ensure the settings are correct - VIp Admin Suite->Toole->Terminal types - double click a type to open the definition window where system FN keys are defined. Sometimes a new Type must be created and the exact codes entered in the window by pressing the appropriate fn key.
In Topic: How do you create a memory file?
22 January 2016 - 07:57 PM
I looked at ProIV's documentation regarding creating memory files (topic ID 720293) and it has left me more confused than enlightened.
I took the simple approach of changing the file type of one of our existing "working files" and regenning all functions that reference it. It seems to have made no difference at all in execution speed of the report I was testing. The documentation also mentions adding an entry to pro4v7.ini which I did but it still makes no difference.
Help!
Chaging to mem file is quite simple - sounds like you did it correctly. with modern file systems there is a lot of caching going on - if this was a pro-isam or c-isam file originally then converting to mem file may not give as much advantage as you might think - replacing a database table based workfile can give huge performance advantages. Perhaps theres is something else slowing your report? What sort of volume of data were you processing using this memory workfile? I'm quite sure if you really pump up the volume you will see a difference.
In Topic: Cannot open function "Unknown Control ID!"
21 January 2015 - 10:02 PM
what versions - kernel, client & proivDeveloper?
- ProIV Resource Centre
- → Viewing Profile: Posts: Chris Mackenzie
- Privacy Policy