Re: Database vs Data Structure?

On Apr 17, 9:30 pm, erikcw <erikwickst...@xxxxxxxxx> wrote:
Hi,

I'm working on a web application where each user will be creating
several "projects" in there account, each with 1,000-50,000 objects.
Each object will consist of a unique name, an id, and some meta data.

The number of objects will grow and shrink as the user works with
their project.

I'm trying to decided whether to store the objects in the database
(each object gets it's own row) or to use some sort of data-structure
(maybe nested dictionaries or a custom class) and store the pickled
data-structure in a single row in the database (then unpickle the data
and query in memory).

A few requirements:
-Fast/scalable (web app)
-able to query objects based on name and id.
-will play nicely with versioning (undo/redo)

Any input on the best way to go?

Thanks!
Erik

When you change an object, what will you do?

1) Changes on disk only.
2) Changes in memory only & flush.

Databases cache a binary in memory, which I find underrated.
.

Relevant Pages

  • Database vs Data Structure?
    ... I'm trying to decided whether to store the objects in the database ... data-structure in a single row in the database (then unpickle the data ... -able to query objects based on name and id. ...
    (comp.lang.python)
  • Database vs Data Structure?
    ... I'm trying to decided whether to store the objects in the database ... data-structure in a single row in the database (then unpickle the data ... -able to query objects based on name and id. ...
    (comp.lang.python)
  • 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)