Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

GP Dyamics OLE Notes structure question

Status
Not open for further replies.

fmcmurray

Vendor
Aug 26, 2008
4
US
Hi All

We doing an implementation of GP 10 for a client, the accounting dept. loves the idea of attaching the OLE Notes to the vendor cards and journal entries. The IT dept is questioning the amount of drives space that will be needed per item. Does anyone have a structure or sizing of the OLE Notes?

Thanks

Fred McMurray
AccessTek LLC
GP Warrior
 
OLE notes are stored in a folder as defined by the OLEPath setting in the Dex.ini.

There will folder for each company with a OLENotes folder. The OLE objects are stored as files with a name representing the 'Note Index' value as Hexidecimal.

The size of the files will be approximately the same size as the files or objects stored in them.

You would need to look at what the customer wants to store to decide how much space will be needed.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)


Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
 
In practice we are usually talking kb's or mb's for the entire OLE folder and all the OLE objects. Size/space is not a major concern with the size of most hard drives today.
 
In nine years of using Great Plains, at one site, the number of files created due to OLE notes is 4,534.
These 4,500 files consumes 8.24Gb space.
Most of these OLE note attachments are Excel spreadsheets.
The largest single file is 55Mb.

In comparison there are 48,433 records in the SY03900 table for text based notes only.
Within the SQL database, this table takes up 51400 KB ( as reported by sp_spaceused ).

------
Robert
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top