IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New key phrase
"pointed it at tables in SQL server on the network"

It's a pile of dung for local storage.

Might give it a go, though. Watching Excel seize up is getting old, fast.
New Oh yeah, the MDB sucks donkey wang
When you use the SQL Server tables I don't know where the search logic actually executes, but I was joining multiple tables with millions of rows each and getting results back sub-second.
--

Drew
New It depends on the ODBC connection...
Since it is a Micrsoft product, the sorts/queries mostly hit the DB.

For things like Oracle, MySQL or PostGreSQL it is a mixture.

Sometimes it is painfully slow... since Access will use the LEAST capable SQL queries... due to "safety." We sped up a query/Join by manually editing it for a customer. Result went from several hours for a report to run clawing through millions and millions of records... sorted locally and manipulated locally. To results from a much smarter initial query with everything returned in the right format plus reduced the return rows to only those needed... reduced it to about 30 seconds fully rendered and "playable"

This was using a SSH tunnel with s local port forward on the "server" using the built in Access MySQL connector.
--
greg@gregfolkert.net
"No snowflake in an avalanche ever feels responsible." --Stanislaw Jerzy Lec
     So, PivotTables are great. - (pwhysall) - (15)
         Tangent, I still like Access - (drook) - (5)
             key phrase - (pwhysall) - (2)
                 Oh yeah, the MDB sucks donkey wang - (drook) - (1)
                     It depends on the ODBC connection... - (folkert)
             Synchronicity - (drook) - (1)
                 "You'd write email in excel if you could figure out how to do it in a font you like." -NT - (boxley)
         Corporate friendly output - (scoenye)
         Do you have an Oracle instance you can load your data into? - (crazy) - (5)
             Not easily available. - (pwhysall) - (3)
                 Have you used Oracle in the past? -NT - (crazy) - (2)
                     Yeah. - (pwhysall) - (1)
                         Very important to gather stats. - (crazy)
             Also, do you have any pictures of kittens? - (pwhysall)
         you have splunk in the house? - (boxley) - (1)
             Eeenteresting. - (pwhysall)

About Three Miles long and right up the wazoo.
120 ms