Compartilhar via

C++ development will speed up with the use of SQL Server Compact

  • Artigo

Jim Springfield, an Architect on the Visual C++ team has just posted a great example of how SQL Server Compact will be used to speed up search time during C++ development.  It's a great example of where traditionally databases were too overkill and in-memory processing with XML or custom collection management is  just too slow. 

What's great about this reference is nobody is more critical about perf than the C++ team. 

IntelliSense, Part 2 (The Future)

The feedback on Jims post are interesting as well. Once you have information in a queryable form, that's also fast, lots of interesting possibilities come up.

This is just one of the great examples where SQL Server Compact is being used. Because Compact is embedded within the application code, you don’t even know it’s being used. “It just works”. There are many other teams at Microsoft using Compact, but can’t talk about all of them just yet. It’s always great to hear about the great scenarios customers have, so if you’ve got a similar scenario, let us know. We’re in the midst of our vNext planning, so the timing is perfect.

 

Steve

Comments

  • Anonymous
    March 09, 2008
    I'm hoping the increased use of SQL Server Compact and C++ by Microsoft developers result in updates to the ATL OLEDB Consumer Templates technology, articles in the MSDN magazine and on the website and a renewed emphasis by Microsoft on providing these C++ oriented database tools for Windows Mobile developers.  Does anyone think these will happen? Twain

  • Anonymous
    March 19, 2008
    I got all excited for a second thinking there was going to be a performance trick for using it in CE, but it's just being used on a desktop machine running VS. Boring. You might as well tell us they started using hashtables instead of iterating through entire lists.

  • Anonymous
    March 29, 2008
    The comment has been removed

  • Anonymous
    April 07, 2008
    Steve, I noticed you never commented on my post about the use of C++ with SQL Server Compact Edition.  Is this just a forbidden topic and C++ developers are simply on their own? Twain

  • Anonymous
    April 10, 2008
    Sorry Twain, No forbidden here.  It's kinda funny to think of C++ as the “forgotten language” after all the VB debates :) The reality is while we have some great people working on Compact documentation, we just don't get a lot of resources and with so much to cover, there’s more focus on Managed languages these days.  If you’re point was updating an article, we’re always interested to have writers. Besides, I thought the C++ developer didn’t need docs :)  Just kidding of course. Steve

  • Anonymous
    April 28, 2008
    Is Microsoft planning on building a browser-based database add-on (ActiveX/CAB) to enable the installation and access of relational data via SQL CE for storing user data for a web application (similar to iso storage, but against a SQL CE engine). Similar to what Google is doing with Gears? http://code.google.com/apis/gears/api_database.html. I was thinking on building an ActiveX browser control in .Net, and have that install and access SQL Compact Edition for Windows for my web application (not mobile or desktop).... are there any efforts on building something like this for SQL 2008 perhaps? Or maybe as an add-on to IE 8?

  • Anonymous
    April 29, 2008
    Building an ActiveX wrapper around Compact is a good solution that would certainly work.  We do believe we can deliver a better experience, but we don't have anything to announce at this point.   Steve

  • Anonymous
    October 11, 2008
    The comment has been removed