Good afternoon!
Good morning, Wesly!
I have 2 tables stkmaster (50k records) and stkgrnchild (180k records) where I
want to get
total quantity received particular stock id.
The sql statement is :
select coalesce(sum(gc.qty_nu),0)
from stkgrnchild gc
join stkmaster sm
on
Sorry I sent one answer accidentally unfinished.
20. 2. 2013 8:28 - Alexey Kovyazin a...@ib-aid.com
Hi Roland,
Hi Alexey,
Terminated abnormally is indication of the server crash, not
database corruption (though it can be some relation).
First of all, you need to look at UDFs you are
hrefofficemanager wrote:
Of course cloud is just a metaphor not a place.
Not all public database servers run on virtual machines. Some are still
physical machines and those often run database engines faster because there
is no VMWare or VirtualBox overhead.
Furthermore you can control the
Hi,
I have a table
T1(id int, name varchar(30))
Sample of data:
Id name
-
1 abc
2 def
10 ghi
6 lal
1000kkk
900 LAL
I´d like a select returning records in random order. Something as:
On 21-2-2013 14:51, Luiz wrote:
I´d like a select returning records in random order. Something as:
Select id from t1 order by RANDOM(id)
http://www.firebirdfaq.org/faq326/
On Thu, Feb 21, 2013 at 3:36 AM, Lester Caine les...@lsces.co.uk wrote:
**
hrefofficemanager wrote:
Of course cloud is just a metaphor not a place.
Not all public database servers run on virtual machines. Some are still
physical machines and those often run database engines faster
Hi,
You wrote it :)
But this is supported by fb2
Try order by random()
Regards,
Karol Bieniaszewski
- Reply message -
Od: Luiz cprm...@gmail.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] select in random order - HELP
Data: czw., lut 21, 2013 14:51
Hi,
I have a
Lester,
While I can understand the theory behind some aspects of 'The Cloud', I
don't see how it can work in the case of some of the 'real-time' applications
that we use Firebird for?
With the correct setup, a cloud deployment could be an ideal solution. It
all depends on the pieces of the
So, it is possible that you can get significantly faster disk IO from such a
solution. At last year's MS NA TechEd, several vendors where showing
Windows 2012 Storage Clusters which had Disk IO throughput of 5 *GBytes*
per second!!!
A clarification/correction.
The actual numbers were
hrefofficemanager wrote:
Costs range from $75 to $400+ per month, plus setup fees.
...in the USA.
If you're in Europe, you can get a pretty decent server from Hetzner
from 20 EUR upwards with 10TB of free traffic per month.
Regards,
--
Milan Babuskov
==
The
Leyne, Sean wrote:
So, it is possible that you can get significantly faster disk IO from such a
solution. At last year's MS NA TechEd, several vendors where showing
Windows 2012 Storage Clusters which had Disk IO throughput of 5*GBytes*
per second!!!
A clarification/correction.
The actual
Leyne, Sean wrote:
So, it is possible that you can get significantly faster disk IO
from such a solution. At last year's MS NA TechEd, several vendors
where showing Windows 2012 Storage Clusters which had Disk IO
throughput of 5*GBytes* per second!!!
A clarification/correction.
thank you very much for this info. Windows licence is added to this price
but so far looks the best. is Windows Server 2008 R2 Web Edition enough for
Firebird? or do I need Standard?
On Thu, Feb 21, 2013 at 8:46 PM, Milan Babuskov mil...@panonnet.net wrote:
**
If you're in Europe, you can
Hello Alexey and others,
I have done today the following:
1. gbak -b -v -m no problem
2. used fbcopy (thanks to M.Babuskov) to copy data to healthy DB
3. gbak -b -v on new database no problem.
Sooo, once again thanks to all of you at least for reading my emails.
Of course especially
After changing the sql statement to :
select coalesce(sum(gc.qty_nu),0)
from stkgrnchild gc
join stkmaster sm
on gc.stkmasterrowid_bi = sm.rowid_bi || 0
where sm.stkid_vc = '38338'
It indeed improve the performance and plan used has been changed to
UNQ1_STKMASTER. The execute time was 63ms
--- In firebird-support@yahoogroups.com, Net Firebird netfirebird@... wrote:
thank you very much for this info. Windows licence is added to this price
but so far looks the best. is Windows Server 2008 R2 Web Edition enough for
Firebird? or do I need Standard?
Firebird imposes no restriction
16 matches
Mail list logo