adodb recordset

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

adodb recordset

Logged in as: Guest

arrSession:exec spGetSession 2,2,52801

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> adodb recordset
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

adodb recordset - 10/18/2007 6:50:32 AM

svm33m

Posts: 2
Score: 0
Joined: 10/18/2007
Status: offline

Hi

i use an adodb recordset object to create a filter on a Huge text file (70 mb) and apply the filter and write to another text file. This seems to be working with a small file but with this huge file it seems to kill or stuck. Is there any other alternative? I am trying to apply some filter on this text file and write the results to another text file.

Rose.

Post #: 1

RE: adodb recordset - 10/18/2007 8:30:16 AM

dm_4ever

Posts: 2724
Score: 46
Joined: 6/29/2006
From: Orange County, California
Status: offline

What are you filtering for? Maybe an example of what you're doing will help us see if there is an alternate way of achieving the same.

_____________________________

dm_4ever

My philosophy: K.I.S.S - Keep It Simple Stupid
Read Me: http://www.visualbasicscript.com/m_24727/tm.htm
Frequently Asked Stuff: http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to svm33m)

Post #: 2

RE: adodb recordset - 10/18/2007 10:51:47 AM

svm33m

Posts: 2
Score: 0
Joined: 10/18/2007
Status: offline

The text file has 6 fields like employee id, date, identifier id, number of yrs experience. within an (employeed id, date) combination there should be only 1 identifier id for this combination. I am trying to set up a filter on this combination. It works perfectly for a small file but for a 70 mb file, it gets stuck. Can u help or suggest a different way out?

(in reply to dm_4ever)