[firebird-support] Inserting/Updating new records with data from previous records

[Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support]]

Hi all, I hope you can help me with this.
I have a customer who scans barcodes to produce delivery notes. There 
may be several barcodes per part to produce one line on the delivery 
note. The quantities can vary - if there is insufficient raw material or 
their customer needs them immediately.
e.g. scan barcode label at goods out department (there's a lot more data 
but this is simplified)

Partno, del_qty no_boxes, (pallet_qty, qty_per_box - do not vary for 
each part)
ABC  200  10300   20
ABC  200  10300   20
ABC  100  5 300   20

delivery note
Partno, del_qty no_boxes
ABC  500  25

So far so good, but some of their customers require a second barcode 
label attached to the outer pallet (the 300 above)

I need to produce 2 pallet labels as follows:
Partno, del_qty no_boxes
ABC 300 15
ABC 200 10
I can easily generate a second identical label like this:
Partno, del_qty no_boxes
ABC  500  25
ABC  500  25

but I need to be able to deduct the second label qty of 200 from the 
total of 500 and the no_boxes of 10 from the total of 25. And of course 
there may be more than 2 labels needed so I'd need 300+15, 300+15, 
300+15, 200+10 for 4 labels for a total of 1100 parts.
I've tried to do this with an SP but can't work it out so any advice 
would be welcome.
Regards
Alan


Alan J Davies
Aldis

RE: [firebird-support] Firebird Backups on Google Compute Engine

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> We are considering moving our systems to GCE and trying to figure the best
> approach to backup our many firebird databases.
> Firebird is not VSS aware so we can't use shadow copying.

Not completely true.

1- Firebird uses careful write order, so a VSS snapshot should be a valid 
database image -- though with pages containing uncommitted data.  So, which FB 
is not VSS aware, it co-exists with VSS quite nicely.

2- You can use nbackup to create a logical DB snapshot, which would be 
equivalent of a VSS snapshot.


> On our current
> host, we create backups of every single database with gbak daily - which
> consumes a lot of time and disk. We would like to improve that.
> Would the following procedure be enough to guarantee a safe differential
> backup? We are on windows :
> 1. connect to all databases and set them to backup mode (or offline mode)
> 2. stop the firebird service
> 3. unmount the drive containing the dbs
> 4. create a snapshot with gcloud
> 5. remount, restart service, put dbs online

Please clarify.

1- Are you moving your databases to run on GCE? 
2- Looking to store backups on gcloud?
3- Both?

If 1 or 3 you need to perform some disk benchmarking.

Unlike some databases, Firebird performance is significantly influenced by IO 
_latency_.

All clouds talk about provisioning IOPS, but few talk about what the latency is 
of each IOP.  You can get 10,000 IOPS if you have 10,000 processes each 
generated 1 IOPS, Firebird is (largely) a single process.  I know that there 
are differences between cloud provider (don't have first hand experience with 
GCE -- hoping soon)


Sean

[firebird-support] Firebird Backups on Google Compute Engine

[rud...@gmail.com [firebird-support]]

We are considering moving our systems to GCE and trying to figure the best 
approach to backup our many firebird databases.
 Firebird is not VSS aware so we can't use shadow copying. On our current host, 
we create backups of every single database with gbak daily - which consumes a 
lot of time and disk. We would like to improve that.
 Would the following procedure be enough to guarantee a safe differential 
backup? We are on windows :
 
 connect to all databases and set them to backup mode (or offline mode) stop 
the firebird service unmount the drive containing the dbs create a snapshot 
with gcloud remount, restart service, put dbs online 

Re: [firebird-support] using a stored procedure to return the value for an existing field in the table

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

24.03.2017 17:26, av...@telusplanet.net [firebird-support] wrote:
> is there a way i can write a StoredProcedure or trigger to have the "code" in 
> the database
> return that value i want for the existing column and not just return the 
> table data for
> that column?

   Create a new table, pump all data into it, drop old table, create a view 
with name 
Parts which select from new table and performs needed calculation, write 
triggers to make 
it updateable. That's all.


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: [firebird-support] reset sysdba password without loose existing users

[startx252...@yahoo.fr [firebird-support]]

OK that's sound me more clear. 

 just another question :  can i modify de sysdba password in this case  with 
gsec ?

RE: [firebird-support] reset sysdba password without loose existing users

[startx252...@yahoo.fr [firebird-support]]

Ok, so must i need to download an ambeded firebird server ? 

 - I just read the documentation and it's seems a little bit complexe to install
 

RE: [firebird-support] reset sysdba password without loose existing users

[talorigo...@yahoo.co.uk [firebird-support]]

What you'll need to do is to download the firebird embedded edition and unzip 
it into a folder.  If you are going to try to change the password from the 
command prompt you'll need to copy the isql.exe file from your original 
installation into the folder where you unzipped the embedded version.  If you 
are going to use a tool like flamerobin copy the fbemded.dll to its folder.  
I'm not sure but you may need to rename it to fbclient.dll for flamerobin to 
use it.  If you are using a tool like IBExpert or DBWorkbench then were it ask 
for the client dll point it to the firebird embeded client.  You'll then be 
able to connect to the security database and issue the commands to change the 
password.
 

---In firebird-support@yahoogroups.com,  wrote :

 Hi, 
  
 What the person meant was that if a database is opened using a firebird server 
process, that process looks for a valid password for the sysdba user. This is 
the situation you are in now.  
  
 But, If you take that Database and open it in embedded mode, meaning that it 
isn’t using the server process. The Embedded mode only looks for the user to 
exist. It doesn’t care about the password. Once you connect, you can then issue 
the appropriate command to change the password.
  
 Thanks,
 Ed Mendez 
  
 From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Sent: Thursday, March 23, 2017 1:05 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] reset sysdba password without loose existing 
users


  
  
 Hi,

Thanks for your reply,

I don't understand what you meansorry

As i said, i don't have sysdba passwordand i don't want to loose all
existing users account

Regards

-Message d'origine-
De : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com 
mailto:firebird-support@yahoogroups.com] 
Envoyé : jeudi 23 mars 2017 17:29
À : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com
Objet : Re: [firebird-support] reset sysdba password without loose existing
users

23.03.2017 17:27, startx252000@... mailto:startx252000@... [firebird-support] 
wrote:

 > Anybody can help me to reset SYSDBA without loose all existing users in
 Firebird

Attach in embedded mode with SYSDBA name and you can change the password
with ALTER 
USER command.

-- 
WBR, SD.





++

Visit http://www.firebirdsql.org http://www.firebirdsql.org and click the 
Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/ 
http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links 

 

Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

[Daniel Rail dan...@accra.ca [firebird-support]]

Hi,

At March 24, 2017, 5:22 AM, Doychin Bondzhev doyc...@dsoft-bg.com 
[firebird-support] wrote:

> Hi,

> I just got my last piece (the motherboard) for my new Ryzen system. I'll
> install all the software during the next few days and will write back 
> here about my experience with FB.

> I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the
> storage (RAID 10 with 6 HDD) so I expect there will be very decent speed
> up for FB.

> At least my personal experience shows that for well written code the 
> biggest problem is the database storage.

> For classic or super classic you will get better results with Ryzen when
> you have multiple clients accessing your database then with KL.

The same can be said with Firebrid 3.0 SuperServer.

> KL is good for super server or for small number of clients where higher
> IPC will help you to process queries faster.

For Firebird SuperServer versions prior to version 3.0, I can see
KabyLake being better. But with Firebird 3.0, SuperServer is truly SMP
compliant, and will use more CPU cores compared to before (but this
still depends on the scenario, as an example: only one application
connecting with only one connection will most likely use the same
number of cores when comparing between version 2.5 and 3.0).

> but all this is irrelevant if you have slow storage.

This is mostly the problem that we face with customers when they
complain that our application is slow.

-- 
Best regards,
 Daniel Rail
 Senior Software Developer
 ACCRA Solutions Inc. (www.accra.ca)
 ACCRA Med Software Inc. (www.filopto.com)

Re: [firebird-support] Ryzen R7 vs Kaby Lake 7700K, which one to choose?

[Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support]]

Hi,

I just got my last piece (the motherboard) for my new Ryzen system. I'll 
install all the software during the next few days and will write back 
here about my experience with FB.

I'm moving from FX-8350 to Ryzen 7 1800X with some decent upgrade on the 
storage (RAID 10 with 6 HDD) so I expect there will be very decent speed 
up for FB.

At least my personal experience shows that for well written code the 
biggest problem is the database storage.

For classic or super classic you will get better results with Ryzen when 
you have multiple clients accessing your database then with KL.

KL is good for super server or for small number of clients where higher 
IPC will help you to process queries faster.

but all this is irrelevant if you have slow storage.

Doychin

On 23.3.2017 ã. 05:00 ÷., trsk...@yahoo.com [firebird-support] wrote:
>
>
> Hi all,
>
> I am considering to upgrade my development cpu.
>
> Between Ryzen & KL, although Ryzen is very good at multi threaded
> processing, I guest, for Firebird, KL will be faster.
>
> For development, mostly I used only single connection to FB, and since
> FB distributed workload among cores, for a single connection, total
> utilization for all cores is the same as 100% utilisation for 1 core,
> and for 1 core operation, KL is more superior than Ryzen.
>
> Can anyone confirm this? Or has anyone here have a Ryzen and care to
> share the experience using Ryzen with FB?
>
> Thanks & regards,
> Anto
>
>
> 


-- 
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116


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







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/