Re: Hashtable faster than SQL ?!!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Steven Wolf wrote:
[...snip...]
> without taking care about the network-time, namepiping etc.,
ms-sql/indexes
> never get such results as the hashtable do.. i saw better results on
> PostgreSQL...
[...snip...]
> i am curious if sql server 2005 will conquer the speed as the hashtable
do...
[...snip...]

Don't expect any database to be even remotely as fast as a "simple" memory
access...
We are using Oracle 9 /10 as a database and even loading 1,000,000 rows of
data from file into memory and searching for a particular object (including
object creation) is faster than a simple query (first execution) against the
index of 1,000,000 rows in the database.


.

Relevant Pages

  • Re: dataset Performence Issue
    ... Microsoft that a DataSet is okay to abuse as a DataBase. ... Managed Code can never be as fast and as optimized ... very good for 90% of the situations i.e. normal memory usage, ... Merge/GetChanges - and oh lets not forget keeping your disconnected cache ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: To Normalize or not ??
    ... The problem is that when you run a split database, ... save a word document (it is in memory, and thus does not get saved). ... ms-access is different then excel or word. ... database server. ...
    (microsoft.public.access.formscoding)
  • Re: TimesTen and In Memory Databases.....
    ... I have been assigned to evaluate the TimesTen in memory database ... Please note I am not a DBA but I do have quite a bit of systems ... This can hurt TimesTen performance (and Oracle ... Right - link Times Ten into your application memory, ...
    (comp.databases.oracle.server)
  • Re: Can I Trust Pointer Arithmetic In Re-Allocated Memory?
    ... and leaving the database in an undefined state. ... memory and leave data it arrived unchanged. ... have already allocated with a null pointer. ... SOME people have to clean up in that fashion. ...
    (comp.lang.c)
  • Re: Memory leak in ASP.NET web site
    ... > I have a web app that makes many queries to the database on every page. ... > string to a method and I am passed a datareader or else individual values ... > There is a horrible memory leak in this application. ... > restored until SQL Server and IIS services are restarted. ...
    (microsoft.public.dotnet.framework.adonet)