Article View: borland.public.cppbuilder.database.ado
Article #4063Re: memory elimination problem
From: Vassiliev V.V.
Date: Fri, 05 Apr 2002 08:43
Date: Fri, 05 Apr 2002 08:43
30 lines
1868 bytes
1868 bytes
You can try OLEDB Direct at http://www.oledbdirect.com. It uses OLEDB interfaces directly, without ADO layer. It is also significantly faster. Using it can be more difficult than ADO. Regards, Vassiliev V.V. http://www.oledbdirect.com "Marc" <wjph@wanadoo.fr> �������/�������� � �������� ���������: news:3cacc4fb_2@dnews... > Hi there, > > I use the C++Builder 5 with Adodb_tlb (generated by c++buider) to create a > large > Access table. I inserted 300 000 rows in a Recordset (with CursorLocation > set to > adUseServer) by AddNew method. The problem is that it's extreamely resource > consuming > (more than 400 Mb of memory) and in particular, after having finished the > insertion, > although the recordset is closed (recordset->Close()), I still could not > eliminate the memory. > Does anyone have an idea ? > > Thanks. > > > >
Technical Details
Message-ID:
<3cad6443_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.cs.utwente.nl!logbridge.uoregon.edu!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3cacc4fb_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,85189fa50eb74c8a X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-04-05 00:53:11 PST From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> Newsgroups: borland.public.cppbuilder.database.ado References: <3cacc4fb_2@dnews> Subject: Re: memory elimination problem Date: Fri, 5 Apr 2002 12:43:08 +0400 Lines: 34 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 62.118.137.199 Message-ID: <3cad6443_2@dnews> X-Trace: dnews 1017996355 62.118.137.199 (5 Apr 2002 00:45:55 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.cs.utwente.nl!logbridge.uoregon.edu!newsfeed.media.kyoto-u.ac.jp!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews