huge table question

[richard_chamberlain]

Hi Bill,

I'm not sure this would be any quicker but you could try accessing it
through com. Have a look at :

http://starship.python.net/crew/bwilk/access.html

for example code.

My guess is that the speed issues you're facing are not a odbc thing (as
that is fairly quick) but an access issue.

Richard




Bill Tolbert <bill_tolbert at bigfoot.com> wrote in message
news:8p6d9p$i5m$1 at nnrp1.deja.com...
> I've got a table in MS Access with 3.5 million records. First, I know we
> should be using something else, but it isn't my call. I need to extract
> newline characters from one of the fields and write it to a tab
> delimited text file.
>
> My problem is getting to the data. I thought I'd fetch a cursor and
> whack away at it. However, just getting the cursor is taking an
> extremely long time. Access will write the data to a 237meg text file in
> about 8 minutes. So far, on the same machine, Python has been at this
> for about 2 hours.
>
> Any better ideas? Ways of speeding it up? Is it the jet engine or the
> odbc drivers or just too much data...?
>
> Thanks,
>
> Bill
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.