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


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 (8)

  1. Twain says:

    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

  2. Jax says:

    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.

  3. Steve.Lasker says:

    Hi Jax,

    Sorry if the title was misleading.  It’s still a cool representative scenario as Compact was able to do a much better job than Hash tables, or other in-memory management collections.  Data sizes are continuing to grow, and this is a good example of where Compact can be used to manage in-memory data, or a replacement for XML, in addition to the typical local database scenarios.

    Steve

  4. Twain says:

    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

  5. Steve.Lasker says:

    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

  6. jcnovoa says:

    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?

  7. Steve.Lasker says:

    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

  8. Boris Jabes 和Damien Watkins将会在 PDC 上演示Visual C++10中的新功能。IDE的新功能包括 基于SQL Compact的智能提示 、 支持自定义插件的新的项目和编译系统