LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 184
Default memory issue using ADO to query Excel

Hi Jamie,

all my questions are answered with my testing, both test only showed the
memory leak and nothing else as cleaning up was the only variable but the
results were the same (= no effect of the variable).

From your earlier post, it seems
you may be experiencing a double leak i.e. one from the open xls and
one from the Foxpro source.


There's no difference when testing the mdb-linked foxpro table with and w/o
cleaning up. you know, I'm testing the vehicle not the head;) I did not pay
enough attention on my first quick test, now, both tests showed 43 sec and
23 MB of RAM with a result table of 540rows x 34cols, 30 queries, Ram
started with 16.8MB.

regards

arno





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum Number Of Worksheets In A Work Book-Not A Memory Issue???? Tickfarmer Excel Discussion (Misc queries) 2 December 18th 07 05:05 PM
Excel 2003 memory issue ngenear11 Excel Discussion (Misc queries) 0 May 26th 06 04:28 PM
Memory or power issue Steven Excel Discussion (Misc queries) 1 May 10th 06 05:06 AM
Charts appear snowy (e.g., tv) unless clicked on. Memory issue? Vlookup help Charts and Charting in Excel 1 December 12th 05 09:17 PM
Pivot Table Memory Issue - Excel crashes rmsterling Excel Discussion (Misc queries) 0 November 11th 05 10:05 AM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"