microsoft access query speed...

Posted by V.S. on Stack Overflow See other posts from Stack Overflow or by V.S.
Published on 2010-12-30T15:56:04Z Indexed on 2010/12/30 16:54 UTC
Read the original article Hit count: 183

Filed under:

Microsoft

|

performance-comparison

|

access

|

ms

Hello everyone!

I am now writing a report about MS Access and I can't find any information about its performance speed in comparison to other alternatives such as Micorsoft SQL Server, MySQL, Oracle, etc... It's obvious that MS Access is going to be the slowest among the rest, but there is no solid documents confirming this other than forums threads, and I don't have the time and resources to do the research myself :(

Hoping for your help, V.S.

© Stack Overflow or respective owner

Related posts about Microsoft

Microsoft Opens Up Silverlight for Windows Phone 7 Series - Microsoft News

as seen on Internet.com - Search for 'Internet.com'
In the latest Microsoft news, software giant announces Silverlight for multimedia Web development is now open source. Could the move spur a bevy of work for Silverlight developers and new apps for Microsoft's Windows Mobile 7 Series? >>> More
Lancement de la plateforme Microsoft Online Services : testez-la et venez en discuter avec Microsoft

as seen on Developper.com - Search for 'Developper.com'
[IMG]http://www.lgmorand.com/blog/image.axd?picture=2010%2f3%2fhome_header-bg+-+Copie.jpg[/IMG] Après le lancement de sa plateforme Azure en début d'année, Microsoft a lancé début mars sa nouvelle plateforme MOS, pour Microsoft Office Services, une plateforme d'outils de communication externalisés… >>> More
C# development with Mono and MonoDevelop

as seen on Developer IT - Search for 'Developer IT'
In the past two years, I have been developing .NET from my MacBook by running Windows XP into VM Ware and more recently into Virtual Box from OS X. This way, I could install Visual Studio and be able to work seamlessly. But, this way of working has a major down side: it kills the battery of my laptop…… >>> More
Differences Between NHibernate and Entity Framework

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction NHibernate and Entity Framework are two of the most popular O/RM frameworks on the .NET world. Although they share some functionality, there are some aspects on which they are quite different. This post will describe this differences and will hopefully help you get started with the one… >>> More
How To Delete Top 100 Rows From SQL Server Tables

as seen on Tech Dreams - Search for 'Tech Dreams'
If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query: DELETE FROM MyTable WHERE PK_Column IN( SELECT TOP 100 PK_Column FROM MyTable ORDER BY creation … >>> More

Related posts about performance-comparison

SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT

as seen on SQL Authority - Search for 'SQL Authority'
Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options. It is clear that performance of the Insert… >>> More
Dictionary looping performance comparison

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following 3 options, I believe there are more: For Each entry In Me Next For i = 0 To Count Dim key = Keys(0) Dim value = Values(0) Next For Each Key In Keys Dim value = Me(Key) Next Personally, I think the For Each is best since the GetEnumerator is TKey, TValue… >>> More
Derby vs PostgreSql Performance Comparison

as seen on Stack Overflow - Search for 'Stack Overflow'
We are doing research right now on whether to switch our postgresql db to an embedded Derby db. Both would be using glassfish 3 for our data layer. Anybody have any opinions or knowledge that could help us decide? Thanks! edit: we are writing some performance tests ourselves right now. Looking for… >>> More
Performance comparison of Dictionaries

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm interested in performance values (big-O analysis) of Lookup and Insert operation for .Net Dictionaries: HashTable, SortedList, StringDictionary, ListDictionary, HybridDictionary, NameValueCollection Link to a web page with the answer works for me too. >>> More
Performance comparison of MemCached with Disk Caching

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I would like to know the performances of Memcached on remote server(on same LAN) with Disk Caching.Besides Memcached is a scalable cache solution, would there be any advantage of using Memcached with respect to performance when compared to disk caching. Regards, Mugil. >>> More