Hello,
the situation:
state for each element (can be 0 or 1 for Example) = 1001000..
Is it faster to insert this in a varchar-field or is it better to store it
in zwenty smallint separate database fields? I would like to analyze it
later.
(read substring or each field)
Thanks in
Hello everybody,
we plan a web-Application with a firebird database. Now I have two options
to prepare the data for the web-client (HTML.).
Option A - a view - returns Data from all Users and the client selects
itself
Option B - a stored procedure with input parameters, the client gets
Hello everybody,
we plan a web-Application with a firebird database. Now I have two
options to prepare the data for the web-client (HTML…).
Option A – a view – returns Data from all Users and the client selects
itself
Option B – a stored procedure with input parameters, the client gets
Hello everybody,
we plan a web-Application with a firebird database. Now I have two
options to prepare the data for the web-client (HTML.).
Option A - a view - returns Data from all Users and the client selects
itself
Option B - a stored procedure with input parameters, the client
Hi Mark,
thank you. I will try the first solution.
Best regards.
Olaf
Your second solution would amount to you creating a database in a
database. It also means that on every request Firebird will have to
retrieve the string as is, and then split that every time. I assume that
using
-- Original Message ---
From: Olaf Kluge olaf.kl...@satron.de
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
On Mon, 16 Apr 2012 16:10:21 +0200, Olaf Kluge olaf.kl...@satron.de
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