[AccessD] The direction of data processing

Hi Shamil and Gustav:

It was mostly because I had full admin rights...everything requested was given full attention...if the priority had been set down there would have been no obvious problem but I would have wondered why the processing was taking days. Hind sight is twenty-twenty of course. ;-)

OTOH, the processing should have never bogged down like that. It was the database concept and implementation that had failed...I was just unfortunate enough to discover its limits at a bad time. I am sure many DBAs had run across those limitations and some decided, let's not just manage this, let's fix it...hence the new distributive database systems we have available today. 

Right now this technology is in its in infancy. The installation process can be complex, the tools provided appear awkward and extracting and inputing data is not SQL. Things will get better...  

Redis ( http://redis.io ) is very new and definitely interesting!

Is it possible that we are straying away from MS Access even though ADO transport may be able to connect to Redis. Now that will be a challenge for pass-through queries. ;-)
 
Jim

----- Original Message -----
From: "Salakhetdinov Shamil" <mcp2004 at mail.ru>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Monday, January 27, 2014 12:38:05 AM
Subject: Re: [AccessD] The direction of data processing

 Hi Jim and Gustav --

<<<
What a moment to bring a potent Oracle server on its knees. That must have
been a cup of coffee you never forget.
>>>
Oracle devs are known(?) to charge their Oracle servers with long running cycled SPs utilizing cursors - wasn't that the case?
As opposed to MS SQL T-SQL devs who mainly write set-oriented data manipulation SPs - so even when processing large data volumes they keep their MS SQL Servers flying... :)

As for NoSQL - Redis ( http://redis.io/ ) somehow keeps constantly popping-up in the IT-related stuff I'm reading - so Redis (and Hadoop) - are on first positions in my NoSQL bookmarks...

-- Shamil

Monday, January 27, 2014 9:13 AM +01:00 from "Gustav Brock" <gustav at cactus.dk>:
>Hi Jim
>
>For the last days I have been struggling with some updating pass-through
>queries, not Oracle but T-SQL.
>No fun. As soon as you have more than a few joins, the code turns nearly
>unreadable. I'm not very good at it, so I had to build the query and the
>joins bit by bit to not lose my feet. I never learn to love this. Give me C#
>please.
>
>What a moment to bring a potent Oracle server on its nees. That must have
>been a cup of coffee you never forget.
>
>/gustav