Reading your various recent posts, I may be wrong, but I think I'm
correct in saying you know very little about databases, Firebird or
otherwise, and that's fine, we all started somewhere.
While people are very willing to help with tips, tricks and solutions to
all sorts of sql problems, they
si_carter_987654321 wrote:
I have two almost identical sets of records, what would be the most efficient
way of detecting records that are different in the table based on a single
column?
If you only want to view the difference, I recommend using FBCopy with
XH option. It creates a nice
ehaerim wrote:
1) Can you tell me more how efficient by keeping blobs outside of the main
table?
It is not really any more efficient. The blob in main table would only
keep blob ID there - actually blob data is stored on a separate database
page. You would essentially be duplicating what
Vander Clock Stephane wrote:
so is it a probleme to have on one server 1000 databases (does it's will
use more memory or more
power resource than a single database) ?
As for Firebird, this depends on the server architecture used and
available RAM and your expectation of concurrent users
Hello,
Firebird have support for create domain that allow me to create a
new type out from existed type.
PostgreSQL support this as well, but it also support create type
(http://www.postgresql.org/docs/8.3/static/rowtypes.html)
that allow to create more complex data types such as struct in C or
yes, but what i want to know if for the same amout of data,
is their any disadvantage (or advantage) to use several database instead
of one ?
On 12/25/2011 3:42 PM, Milan Babuskov wrote:
Vander Clock Stephane wrote:
so is it a probleme to have on one server 1000 databases (does it's
will
hello,
is it a bug
gbak -CREATE_DATABASE -buffers 0 ... = gave an error :(
thanks by advance
stéphane
Vander Clock Stephane schrieb am 25.12.2011 um 17:54 (+0400):
yes, but what i want to know if for the same amout of data,
is their any disadvantage (or advantage) to use several database
instead of one ?
More maintenance? Imagine altering your schema for 100 databases. Then
again, there's
At 02:51 AM 26/12/2011, ik wrote:
Firebird have support for create domain that allow me to create a
new type out from existed type.
PostgreSQL support this as well, but it also support create type
(http://www.postgresql.org/docs/8.3/static/rowtypes.html)
that allow to create more complex data
Hello,
on the paper nbackup look wonderfull, but what are behind the wood that
we need to know ?
for exemple i see that during the backup, the database file is locked
and all write are done in a separate delta file ... is this can slow
down the server ? especially when the separate file is
Hello, Vander!
Sunday, December 25, 2011, 10:57:32 PM, you wrote:
VCS for exemple i see that during the backup, the database file is locked
VCS and all write are done in a separate delta file ... is this can slow
VCS down the server ?
VCS especially when the separate file is merge back with
VCS
Hello, Vander!
Sunday, December 25, 2011, 5:56:45 PM, you wrote:
VCS hello,
VCS is it a bug
VCS gbak -CREATE_DATABASE -buffers 0 ... = gave an error
I'm curious, what error, and why you ever need -buffers 0
in the command line, since it is default value for the new
created database?
--
Hello, Vander!
Sunday, December 25, 2011, 5:54:51 PM, you wrote:
VCS yes, but what i want to know if for the same amout of data,
VCS is their any disadvantage (or advantage) to use several database instead
VCS of one ?
I don't see any need to keep 1000 client's data in one database,
except you
Cheers,
Ann
On Dec 22, 2011, at 4:12 AM, Vander Clock Stephane svandercl...@yahoo.fr
wrote:
Hello,
I have a problem that i thing any web site can have !
Let say i m a car dealer WebSite and want to permit user to search my
zillions car Firebrd database
Typycal search will be
Stephane,
I have a problem that i thing any web site can have !
Let say i m a car dealer WebSite and want to permit user to search my
zillions car Firebrd database
Typycal search will be
SELECT
FIRST 100 SKIP 0,
*
FOR
CAR
Where
NAME = 'BMW' AND
LOCATION = 'NEW
not sure i understand :)
On 12/26/2011 11:11 AM, Ann Harrison wrote:
Cheers,
Ann
On Dec 22, 2011, at 4:12 AM, Vander Clock Stephane
svandercl...@yahoo.fr mailto:svanderclock%40yahoo.fr wrote:
Hello,
I have a problem that i thing any web site can have !
Let say i m a car
thanks dmitry !
On 12/26/2011 1:54 AM, Dmitry Kuzmenko wrote:
Hello, Vander!
Sunday, December 25, 2011, 5:54:51 PM, you wrote:
VCS yes, but what i want to know if for the same amout of data,
VCS is their any disadvantage (or advantage) to use several database
instead
VCS of one ?
I
17 matches
Mail list logo