Subject Re: [firebird-support] performance question
Author Ann Harrison
On Mon, Apr 16, 2012 at 10:10 AM, Olaf Kluge <olaf.kluge@...> wrote:

> Now I have two ideas. I create a table with all fields (separate for each
> information) and an import stored procedure fill this table with
> information
> from the long string. (line_number = substring(:str_in from 1 for 4)) etc.
> String: 1234A1E2WEWE3432334
> Into Field 1 = 1234, Field 2 = A1, Field3..
> Or
> I made a table with one field and save only the complete string in it.

If you're ever going to search on values of the fields, the first approach
is the
only one that makes sense.

Good luck,


[Non-text portions of this message have been removed]