Re: Long text fields


None wrote:
> Here are the QM answers....
>
> dawn wrote:
> > 1. I haven't looked it up for any particular db, but is there a
> > standard longest field across pick environments? (An actual dtabase
> > storage restriction)
>
> QM will support strings up to 2Gb throughout. Of course, you probably
> run out of other resources before you hit this limit.

Yes, that is excellent. I won't come close.

> > I would like the database to work in openQM and UniData, but would also
> > like it to be compatible with the others -- UniVerse, Revelation,
> > jBASE, D3, UniVision if I ever made the application work with those.
>
> As an aid to cross-platform portability, QM always sets a define token
> named QM. Thus you can insert code such as
> $ifdef QM
> ...qm stuff...
> $else
> ... non-qm stuff...
> $endif
>
> How nice it would be if the other vendors did this too.

I agree. And of course I'd also like that standard data source
definition and connectivity for use with all client-server access
across all flavors and within all languages. ;-)

>
> > 2. I realize the FMT is for display, not storage size, but is there a
> > maximum in the FMT in the dictionary, such as FMT(99999T)?
>
> Contrary to its general design policy, QM does impose a limit here of
> 4096 characters.

That's too small for the field, but I can start with that.

> If someone came up with a realistic reason to want
> this to be bigger, I'm sure we would do it.

I don't know enough to know my options yet. Thanks.

> > 3. Are there performance implications if I make a long single-valued
> > text field instead of multivalued short lines of text? Other
> > implications?
>
> This all depends what you are trying to do. A bit more information
> would help. Mutlivalueness (new word) is usually determined by the
> nature of the data, not some arbitary string length consideration.

Yes, I agree. The text is all a single "script" as in the "script" of
a 30-minute TV show (for lack of better term -- more information once I
have the design complete). My original thinking was to handle these
documents using XML at the file system and simply store a URL. But I
want to consider queries against this data as well as the other that is
stored, which is why I would like to store it in the database.

> > 4. These questions might not even be the right ones, so what do you
> > consider to be "best practices" related to long text fields in an MV
> > environment where the application code will be in languages other than
> > DataBASIC (e.g. PHP), retrieving data using a dictionary definition.
>
> An explanation of what this long data represents would be useful.

After I think about it a bit more, I might catch you offline on that,
but if you think of it as scripts as indicated above it will give you
an idea of the nature and length of the data.

Thanks a bunch. --dawn

>
>
> Martin Phillips, Ladybridge Systems.

.

Relevant Pages

  • Re: Can Oracle IFS do this ???
    ... > we hold no in-depth knowledge about the capabilities of the database. ... > file system and then store files in a more convenient way. ... but behind the scenes it will store the files in a database. ... In this example we will set the RecordID to ...
    (comp.databases.oracle.server)
  • Re: Uploading Files Should I use MySQL or Server for storage?
    ... The files sizes ... I store most of my data in both. ... when i do image processing i usually upload the image, store the original in the database, process the image into its subsequent sizes or resolutions and store them on the file system. ... If the images get lost on the file system or my application can not find them I have the original stored in the db for reprocessing. ...
    (php.general)
  • Re: meta data & full text search
    ... Even longhorn with its SQL based file system still uses file system to store ... According to the "rule of thumb" i should store them in the file system. ... > storing the files in a SQL Server table's column defined with an IMAGE ... > consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Storing Images?
    ... I should add that, in fact, a file system *is* a database. ... Btw, if the web site is a web farm, how to store image to a centralized ... Generally, if the images need to be catalogued, you can use a database to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)