Re: OK, it's the matter of database structure rather

Dnia 17.09.2007 Cesar Rabak <csrabak@xxxxxxxxxxxx> napisał/a:

Once you decide to use the db engine, you'll design the schema and use
the Tcl interface to fetch or add/update data in the db.

I'm afraid, you're identifying a database (an abstract) with a database
storage (a real thing). SQLite-file can be such storage, or just "plain
text file". Doing "select" I'm fetching the necessary data from such
storage.

Or you still insist in getting a lot of data, cache it in structures
coded in Tcl to manipulate them?

Why "or"? I can't see any contradictions(?) in your two paragraphs above.

Only in the last case your phrase '...must be in some way be take into
consideration..." would make sense (at least to me :-).

...I'm wondering - after all this discussion - whether can be possible
action (almost) directly on the database contents. Although up to now I was
always fetching the data from SQL-server into some structure, the tight
integration of SQLite with Tcl perhaps allows to omit such step? I'm not
sure about influence on performance - even using :memory: there must be
some influence - but maybe it'll be fast enough anyway?


Without knowing a little bit about your data and the volume of it,
answering this would be guessing.

How - in your opinion - it's depending on the kind and volume of data?
--
ZB
.

Relevant Pages

  • Re: OK, its the matter of database structure rather
    ... the Tcl interface to fetch or add/update data in the db. ... SQLite-file can be such storage, ... sure about influence on performance - even using:memory: there must be ...
    (comp.lang.tcl)
  • Re: reiser4 plugins
    ... And have you ever heared of the problem of Wikipedia storage? ... reduced the database by 85%). ... Reiser4 won't provide anything but the storage part. ... What userland tools you use to acess this filesystem is upon your decission ...
    (Linux-Kernel)
  • Re: reiser4 plugins
    ... > an entire new storage array and this wasn't/isn't cheap. ... > following versions of an article; reduced the database by 85%). ... So a filesystem with intelligent ... Any "unnecessary double work" would squarely be within ReiserFS... ...
    (Linux-Kernel)
  • Re: The Zen nature of a Delphi database application
    ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
    (comp.lang.pascal.delphi.misc)
  • RE: Data storage solution advice sought...
    ... Data storage solution advice sought... ... > database, as it will allow. ... > my development), XML files, Pocket Access, SQL Server 2005 Mobile. ...
    (microsoft.public.dotnet.framework.compactframework)