back to article Microsoft blesses the clouds down in Africa in full-blown Azure-gasm

With Premium Blobs, Azure DevOps Server and a new Africa Azure region, Microsoft has spaffed out cloudy goodness like a Roomba in reverse. (Premium) Blobby, Blobby, Blobby! Blob storage in Azure is a flexible thing. It is unstructured and can scale up and down as needed. It can be immutable. You only pay for what you use. Heck …

  1. KrytensHoover

    "Microsoft has spaffed out cloudy goodness like a Roomba in reverse"

    I lol'd. Good work.

    1. bombastic bob Silver badge
      Devil

      when I read the title, I thought I heard the band 'Toto' playing the 'Africa' song...

  2. Jay Lenovo Silver badge
    Meh

    Great!, Super?, or not

    If they can find plastic contamination at the bottom of the Mariana Trench, Azure Cloud residing in Africa was long overdue.

  3. bombastic bob Silver badge
    Devil

    Slow BLOB's in Azure? I think I know why...

    I'm going to guess that the BLOB speed is the back-end... having messed with SQL Server a couple o' decades ago, where BLOB storage was done in a FILE SYSTEM rather than in the DBMS, deliberately. It was also compatible with the 'Jet' engine this way, too.

    POSIX file systems are probably more efficient for handling large numbers of files in a directory. but normally an indexer and 'balancer' algorithm [using the generated file names, let's say] will spread it around the file system in a way that IS efficient. So, ideally, no one directory will have more than 4k files in it, including the tree of directories leading up to the one that has the actual file in it.

    Windows systems, from what I recall, are not all that efficient when it comes to directory structure, especially when the directory contains thousands of files.

    A simple google search led to this stack overflow article, which has some interesting performance observations in it:

    https://stackoverflow.com/questions/197162/ntfs-performance-and-large-volumes-of-files-and-directories

    In short, lots of files in a directory on windows, and you get performance problems. If SQL Server or Azure is storing BLOB data in a file system, this could be the problem. And if BLOB storage is going into something "like a file system", keep in mind that the same company wrote NTFS's file system, too. BLOB storage is probably STILL a performance problem with SQL Server.

    I saw 'FILESTREAM' mentioned in one place. It's not something I've used but sounds similar to things I've implemented 'the hard way' i.e. put filename in character column in a table, and then create the actual file with the data in it, in a predictable place, making sure the name is unique beforehand. There are no transaction rollbacks on the BLOB this way, but it's most likely faster so if you create the file first, and then do the transactions in the DB, you can roll them back as needed and manage the file system separately...

    anyway I think this might explain SQL Server's (and Azure's) BLOB performance problem. (not sure they have actually FIXED this, either, just made it 'less bad' maybe?)

    1. Just Enough

      Re: Slow BLOB's in Azure? I think I know why...

      Azure BLOB storage has nothing to do with SQL Server BLOB storage.

  4. Anonymous Coward
    Anonymous Coward

    https://www.youtube.com/channel/UCfZm6BXVnixnsux_YcoPFPA

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2019