473,327 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

How to manage memory problems to see more than 500KB in just one field in the screen?

41 32bit
I have made a small application in Acces that nowadays is more than 70Mb big.
In a function of the software, I have to transform a lot of records in just one text that has more than 500KB. The reason for viewing such information is that it is a history acumulated from some years and some times must be analysed at once.
I can put everything togheter in the record, but when I try to see the content in the screen, I get a message "Out of Memory".
How can I manage a lot of memory in just one simple record?
Best Regards
Ricardo de Milano
Jan 30 '11 #1

✓ answered by TheSmileyCoder

Hi and welcome to Bytes

Im assuming your data is text (memo field) and can't help but wonder why you would want to display 500k of data?

Memo fields can hold alot of data (I think the limit is 2million charecters, but don't remember for sure) but can only display 64.000 charecters. Im guessing this is what your experiencing.
Also using the standard access interface you will only be manipulate strings of (max) 64.000 charecters, while using code you can manipulate larger strings.

Now I dont know what your function does, but if you dont need to display the value, you can handle the processing "behind the scenes". You will need to supply some more information to help you further.

If your access database is growing, you can do a "Compact and Repair" to free up unused space.

2 1607
TheSmileyCoder
2,322 Expert Mod 2GB
Hi and welcome to Bytes

Im assuming your data is text (memo field) and can't help but wonder why you would want to display 500k of data?

Memo fields can hold alot of data (I think the limit is 2million charecters, but don't remember for sure) but can only display 64.000 charecters. Im guessing this is what your experiencing.
Also using the standard access interface you will only be manipulate strings of (max) 64.000 charecters, while using code you can manipulate larger strings.

Now I dont know what your function does, but if you dont need to display the value, you can handle the processing "behind the scenes". You will need to supply some more information to help you further.

If your access database is growing, you can do a "Compact and Repair" to free up unused space.
Jan 30 '11 #2
Ricardo de Mila
41 32bit
Thank you very much.
I think I handle from here.
The doubt is solved.
Best Regards Ricardo de Milano
Feb 1 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DJTB | last post by:
zodb-dev@zope.org] Hi, I'm having problems storing large amounts of objects in a ZODB. After committing changes to the database, elements are not cleared from memory. Since the number of...
5
by: Justice | last post by:
Currently I'm doing some experimenting with the XMLHTTP object in Javascript. Now, the XMLHttp object is asynchronous (at least in this case), and the following code causes a significant memory...
12
by: Eva | last post by:
Hi, I try to implement quick sort. I sort vectors by their first value. 10 2 3 4 9 3 5 6 10 4 5 6 must be 9 3 5 6 10 2 3 4 10 4 5 6 The prog works great on maybe 500 vectors, but I have an...
1
by: Amy L. | last post by:
I am working on creating a web service that will create a signed xml file. I would like to create this file in memory and than somehow email it to the user that requested it to be generated. I...
21
by: matvdl | last post by:
I have a system that was originally developed in asp - the pages are saved in SQL (there are over 10,000 pages) and saved to a temp directory in the server when requested by a client. I have...
12
by: Jeff Calico | last post by:
I have 2 XML data files that I want to extract data from simultaneously and transform with XSLT to generate a report. The first file is huge and when XSLT builds the DOM tree in memory, it runs...
3
by: cmills28 | last post by:
Hi. I'm developing a php 4.3.10 script, extracting data from webpages. Using string functions (strpos, substr) alot, some arrays (both static & dynamic) also data is going to a MySQL 5 DB. Am...
1
by: Nathan Bates | last post by:
Are the Python developers running Python under Valgrind? If not, FYI, Valgrind is a excellent memory-checker for Linux. Valgrind is reporting a ton of memory problems. Worrisome are "Conditional...
11
by: seberino | last post by:
Suppose a C extension locally built an array of PyObject* 's as follows... my_array = malloc(n * sizeof(PyObject*)); for (i = 0; i < n; i++) { my_array = PyList_New(0); } Q1: Must I do a...
0
by: torrchula | last post by:
We have a memory issue when generating pdf files via Apache FOP. So, we just would like to know that is there any FO processor that consume memory less than it? Thanks in advance.
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.