Board index » delphi » ADO+GRID or DBE+GRID memory usage

Zsédenyi Zoltán

Delphi Developer
Tue, 14 Jan 2003 03:00:00 GMT

ADO+GRID or DBE+GRID memory usage

Hello.

I have some questions, problems with the DBs memory usage. I have created an
Application witch is uses only ONE table.
The facts:
1. My record calculaded size is: 790 byte
2. My table containing 11,370 record
3. Estimated memory usage aproximately 790 * 11,370 eq to 8,982,300
4. i tried to use this data with ADO, and BDE  with more formats -  i put
this table to DBF, or PX, or MDB or XLS,  (px db size: 9,127,936, mdb size:
4,968,448)
5. when i opening mdb, the TADOQuery + TDBGrid will allocate 34 MB
memory!!!!
6. when i opening mdb, the TQuery + TDBGrid will allocate 30 MB memory!!!!

Please help me!
Why?

Z.

 
Vassil Nazaro

Delphi Developer
Sat, 18 Jan 2003 03:00:00 GMT

Re:ADO+GRID or DBE+GRID memory usage


Use a WHERE clause. The more extensive the use the better.

HTH
--
V. Nazarov
IT Manager, Sofia Cable

Peter Kan

Delphi Developer
Mon, 20 Jan 2003 03:00:00 GMT

Re:ADO+GRID or DBE+GRID memory usage


I'm not an ADO expert, but I understand that, depending upon the database
provider and the cursor type, it is quite possible for ADO to store three
copies of the data: the original values, the updated values and the
"underlying values", i.e. the values "now" (ish).  This is so that it can
determine what to do when you apply updates.

Peter Kane

Quote
Zsdenyi Zoltn wrote in message <8lrhku$3...@bornews.borland.com>...
>Hello.

>I have some questions, problems with the DBs memory usage. I have created
an
>Application witch is uses only ONE table.
>The facts:
>1. My record calculaded size is: 790 byte
>2. My table containing 11,370 record
>3. Estimated memory usage aproximately 790 * 11,370 eq to 8,982,300
>4. i tried to use this data with ADO, and BDE  with more formats -  i put
>this table to DBF, or PX, or MDB or XLS,  (px db size: 9,127,936, mdb size:
>4,968,448)
>5. when i opening mdb, the TADOQuery + TDBGrid will allocate 34 MB
>memory!!!!
>6. when i opening mdb, the TQuery + TDBGrid will allocate 30 MB memory!!!!

>Please help me!
>Why?

>Z.

Other Threads

1. 2 or 3 Tier deep grid (grid inside another grid)

2. 2 or 3 Tier deep grid (grid inside another grid)

3. Grids Grids Grids

4. Grid usage

5. Grid similar to Netscape Grid

6. Grid with subset (grid) feature

7. I need a grid control like the grid in ms word

8. string grid - grid line colors

9. Coloring Grid or Grid Fonts

10. How to drag record from grid to grid