Jump to content


Photo
- - - - -

How do you create a memory file?


1 reply to this topic

#1 mikelandl

mikelandl

    Expert

  • Members
  • PipPipPipPip
  • 101 posts

Posted 23 November 2015 - 02:35 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!



#2 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 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.


The content and views expressed in this message are those
of the poster and do not represent those of any organisation.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users