Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: accessing MS Access databases

by sundialsvc4 (Abbot)
on Oct 16, 2010 at 00:02 UTC ( [id://865591]=note: print w/replies, xml ) Need Help??


in reply to accessing MS Access databases

Granted, I do not understand in detail (yet...) the approach that you are taking, but when you refer to “OLE” instead of a DBI (ODBC...) database driver, well, I rather immediately become nervous.   You do not need to approach MS-Access, the Application, when you can directly approach Jet, the Database Engine.

Nevertheless, your experience is not atypical.   Many database engines (and I do not recall if Jet is of them) provide “fast track” methods for importing large amounts of data from predictably-formatted files.   If they do so, they probably provide a non-standard way to do this in SQL.   (Microsoft, on the other hand, provides a “flat file” database driver, which is a very nifty trick.)

While the completion-times that you are experiencing with your present approach are by no means “a show-stopper,” I agree that they suggest that you have not yet found the most appropriate strategy yet.   “Think outside the box,” and even (if appropriate), “think outside the Perl.”

Please give us all more details: of what you are doing, and of what you find.

Replies are listed 'Best First'.
Re^2: accessing MS Access databases
by BrowserUk (Patriarch) on Oct 16, 2010 at 00:23 UTC
      I thought it was pretty clear sundialsvc4 knows what OLE is. Hence the advice about addressing the engine via DBI rather than the application via OLE.

        Maybe I misread him, but it sounded an awful lot like:

        "Hi, when I make Yorkshire puddings, they don't rise properly. What Gas mark should I use?"
        "If you get an electric fan oven and set it to the right °Centigrade, they should rise fine."

        Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
        "Science is about questioning the status quo. Questioning authority".
        In the absence of evidence, opinion is indistinguishable from prejudice.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://865591]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others romping around the Monastery: (1)
As of 2024-04-25 03:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found