Allow at backup time possibility to order data in tables
---------------------------------------------------------
Key: CORE-3668
URL: http://tracker.firebirdsql.org/browse/CORE-3668
Project: Firebird Core
Issue Type: New Feature
Components: GBAK
Reporter: Karol Bieniaszewski
Hi,
is possible to see feature to order at backup or restore process
(i suppose at backup this will be simpler to implement but i do not know
internal FB work)
ordering data in pages for table in some way
example invoices
in normal work you store new invoices for many clients
and after 4 years you have e.g. 10 000 000 invoices
data stored in table look like table INVOICES
database page 1
client 1 ....
client 2 ..
client 3 ..
..
database page 2
client 4
client 5
...
database page X
client 1 ..
client 3 ..
client 2 ..
...
and now we do select invoices for "client 1"
what happend?
server locate data for one client from many pages - and disc usage is very very
big
i think that all records are on different pages for e.g. "client 1" an hard
drive must move head as many times as is count of invoices for client
will be good to see something like this (or other solution - the best will be
ordering data in pages for running database)
when we can post some script code at backup time
like gbak 127.0.0.1:d:\baza\bazaX.fdb -order_table "INVOICES" -order_by
"CLIENT_ID ASC"
after that data in table INVOICES will be look like
database page 1
client 1 ....
client 1 ..
client 1 ..
..
database page 2
client 1
client 1
client 1
...
database page X
client 2 ..
client 2 ..
client 2 ..
...
//this is correlated but not the same to my CORE-2708
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
