Re: [firebird-support] Performance issues with ORDER BY
SELECT Table1.ID, Table1.FKID, Table1.MD... some other fields FROM Table1, Table2 , Table3 WHERE 1 IS NOT NULL AND (Table2.ID = Table1.FKID) AND (Table2.FKID = Table3.ID) AND (Table3.ComputationID = 9) ORDER BY Table1.ID ASC; I'd welcome any insight as to what I might be doing wrong. < The first thing I would try would be to update your query format. Try: Select Table1.ID, Table1.FKID, Table1.MD ... other fields >From Table1 Inner Join Table2 on (Table1.FKID = Table2.ID) Inner Join Table3 on (Table2.FKID = Table3.ID) and (Table3.ComputationID = 9) Order by Table1.ID ASC/DESC; HTH Woody (TMW)
Re: [firebird-support] How do find duplicates in a table?
Try this instead: Select Soc_Sec_No, count(*) from Person group by Soc_Sec_No having count(*) > 1 This will list the social security numbers and the count if there are more than one without all the additional selects. HTH Woody (TMW) -Original Message- From: 'stwizard' stwiz...@att.net [firebird-support] Sent: Thursday, February 04, 2016 1:37 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] How do find duplicates in a table? I had finally figured it out just before your reply SELECT DISTINCT P.SOC_SEC_NO, (SELECT COUNT(*) FROM PERSON P2 WHERE P2.SOC_SEC_NO = P.SOC_SEC_NO) AS CNT FROM PERSON P WHERE P.SOC_SEC_NO IS NOT NULL GROUP BY 1 HAVING (SELECT COUNT(*) FROM PERSON P3 WHERE P3.SOC_SEC_NO = P.SOC_SEC_NO) > 1 This appears to work. See anything that I should change? -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, February 04, 2016 1:25 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] How do find duplicates in a table? 04.02.2016 20:09, 'stwizard' stwiz...@att.net [firebird-support] wrote: > How do I form a SQL Select statement that will return which records in > my PERSON table have duplicate SOC_SEC_NO. RTFM GROUP BY, HAVING, COUNT(). -- WBR, SD. Posted by: "stwizard" ++ 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
Re: [firebird-support] Users for application
One of the main reasons I have for using individual user names is to be able to see who created/modified records. In an industrial system such as the one I built and support, knowing who does what is very important, especially if something gets entered wrong or changed inadvertently. Management likes to know who is doing their job efficiently and who isn’t. Woody (TMW) From: mailto:firebird-support@yahoogroups.com Sent: Thursday, June 23, 2016 6:46 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Users for application You can still see which process is doing what using a single user, though, since the system tables provide you with process name (foo.exe) and ip address for each transaction. I have the feeling that users are only worth the management cost if you're in a big corporation with a bunch of developers and lots of users connecting to the database. Then you would use roles and privileges appropriately (with a DBA taking care of this, not the developers). But that's just a feeling really, since I've never been in such a scenario. Em qui, 23 de jun de 2016 às 05:30, Tim Ward t...@telensa.com [firebird-support] escreveu: On 23/06/2016 03:17, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: Separate from security theories and considerations of "good practice", what, if any, benefits accrue from using multiple users when accessing a Firebird database? We have different processes using different users. This means that poking around in the database to see what's going on (performance, long-lived transactions, etc) is a bit easier - we can instantly see which process is doing what, as the users are named after the processes. -- Tim Ward
Re: [firebird-support] gbak error
Not sure it helps, but I once had my FB backup schedule service stop working after a server software update. It was a Windows server, though, so not sure it applies here. Just something else to think about. Woody (TMW) From: mailto:firebird-support@yahoogroups.com Sent: Tuesday, August 30, 2016 3:36 PM To: firebird support Subject: Re: [firebird-support] gbak error no, not a file name collision and plenty of disk space this just started happening, no change to installed s/w Nick Upson, Principal Operations Engineer, Telensa Ltd. Direct +44 (0) 1799 533252, Support Hotline +44 (0) 1799 399200 On 30 August 2016 at 21:14, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: Hello Nick, > I'm running fb2.1 on centos5, recently a system has started > throwing this error when asked to do a backup, the gbak parameters > are unchanged, permissions all seem ok, any suggestions what I might check > gbak: ERROR:Unexpected I/O error while writing to backup file > gbak:Exiting before completion due to errors "gbak parameters are unchanged." Could be you already have a file in that location with the same name. HB