See my replies below
On Tue, Sep 3, 2019 at 1:13 PM Elton Fadel galdari...@yahoo.com.br
[firebird-support] wrote:
>
>
>
> Thanks, Mark! *It worked!*
>
> I also notice something very interesting during my tests:
>
> 1. No matter if you use Firebird if a Service or Application, even without
> inst
Hi,
Thank you for the explanation, will optimize index, i've tried to add index
on TANGGAL_CETAK, and it really work faster and as expected, showing index
read as much as needed only, not all record.
On Tue, Jun 18, 2019 at 11:33 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wro
Hi,
The plan is using ORDER, it read through index, in my system, i need to
load 1 millions of records and i only expect the server to read 1 millions
of records only, not all the data in the table. I already use high speed m2
SSD Samsung EVO 860 series, it still need a lot of time to load.
The pr
t the query is using NOMOR as the index and of course don't have to
read all the record just to order them, but the query plan is using ORDER
and it read all 55 millions records to get 1 millions records? Is this as
design?
Thank you
On Tue, Apr 23, 2019 at 11:45 AM Iwan Cahyadi Sugeng &l
Hi,
The data is repeated and most records are empty value, it will be filled
after a process. But will try to add index on it
Thank you
On Tue, Apr 23, 2019 at 11:35 AM liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
>
>
> Hi
>
> As you can see, your query do not use any ind
Hi,
I'm using Firebird 2.5.8 win 64, i have 33 millions data on one table
Here is the DML :
CREATE TABLE TBAT_ITM (
ID_TBAT_ITM ID NOT NULL,
ID_TBAT ID,
KODE_MESIN KODE,
NOMOR ID,
TANGGAL_CETAK WAKTU,
REVISION REVISI,
CREATED_BY ID,
CREATED_DATE WAKTU,
MODIFIED_BY ID,
MODIFIED_
what is your connection string, don't use localhost:dbname format. Try use
only the filename. Try ems sql manager for firebird, it has embeded protocol
On 14 Sep 2014 19:01, "Adam adam...@gmail.com [firebird-support]" <
firebird-support@yahoogroups.com> wrote:
>
>
>
>
> On Sun, Sep 14, 2014 at 9:5
ute embedded with FreeAdHocUDF and I never
> place gds32, or any other file in system32
>
> Alan
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
FINET-Logo
>
> *ASSFINET Dienstleistungs-GmbH*
> Max-Planck-Straße 14 * 53501 Grafschaft bei Bonn
> i...@assfinet.de <mailto:i...@assfinet.de> * www.assfinet.de
> <http://www.assfinet.de/>
>
> Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
> Registergericht Koblenz HRB 23331
>
> Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
> richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
> informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
> Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
> nicht gestattet.
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
and no traffic.
> Yahoo is going to delete it on March 6 unless I inform them that we want to
> keep it.
>
> Do we want to keep it?
>
> Helen
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
atabase, all other client
will communicating with this server application. In short, it is like a web
server in delphi. You can access them using TCP or HTTP/HTTPS, if you are
using TCP, you need VPN for security, otherwise you can use HTTPS for more
secure protocol.
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
Hi,
Are you having this problem when there are more than one user in
transaction at the same time
i'm guessing the problem is the child table have different parent key.
Check in the child table wether the parent key is correct.
The problem maybe because the child get a different parent key becaus
nix.com
>
> ++++++
> Yahoo! Groups Links
>
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
On 1 Aug 2013 13:47, "Lester Caine" wrote:
>
>
>
> I'd second that ...
> Managing metadata should ALWAYS be detached from anything to do with
data. In
> fact the only metadata changes to our historic data over the years has
been the
> addition of a few extra fields.
>
> And Aldo's comment about 'U
On 1 Aug 2013 04:12, "un_spoken" wrote:
>
>
>
>
>
> --- In firebird-support@yahoogroups.com, Aldo Caruso
wrote:
> >
> > Lester,
> >
> > Thanks for your advice. I'll take it into account, because also I
> > think that having two tables is a duplication of work ( not only for
> > moving records bet
On Wed, Jul 31, 2013 at 4:28 PM, Lester Caine wrote:
> **
>
>
> Iwan Cahyadi Sugeng wrote:
> > I'm planning to do historical data archive too, and still searching what
> > the best strategies to use. For me, it is best to separate the historical
> > tab
c Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk
> Rainbow Digital Media - http://rainbowdigitalmedia.co.uk
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
[Non-text portions of this message
> >
> > > Hi!
> > >
> > > Are there any known incompability issues?
> > >
> > > Thank you!
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
--
lick the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++
> > Yahoo! Groups Links
> >
> &g
tation/papers_presentations/html/paper-fbent-acid.html
> http://ibexpert.net/ibe/index.php?n=Doc.TransactionOptionsExplained
>
> Werner
>
>
> [Non-text portions of this message have been removed]
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
[Non-text portio
i am try to create PivotTable via ms excel using odbc drivers and errors come
sql error code = -104
token unknown -line 1, column 33
i am using ms excel 2010 64 bit, firebird 2.5.2 32 bit, odbc driver 2.0.1 64
bit, fbclient.dll 2.5.0.26074
can somebody help? thanks.
iles causing a conflict even though
> I removed it? Could this be why IB Expert will work, but my application
> won't?
>
> Try check for the fb port in the firebird configuration and with the one
on your apps. also try to look for the client library version you use, look
in the applicat
On 29 Jun 2012 01:02, "Mark Rotteveel" wrote:
>
>
>
> On 28-6-2012 16:44, nathanelrick wrote:
> > Hello,
> >
> > what tool do you use to visually make a "graph" of a database ?
> > Actually i use Visio, but it's slow, and most of all it's not possible
to see diff between 2 visio files
> >
> > than
Yes, thanks for the correction, i've read the vulcan project long ago, so i
can't remember the exact news about it, all i know that fb 3 is planned to
merge vulcan and firebird to have better support on SMP.
On Tue, Jun 5, 2012 at 3:37 AM, Michael Ludwig wrote:
> **
>
>
&g
out it's an FAQ I've never seen before:
>
> http://www.firebirdfaq.org/faq245/ - What is Vulcan?
>
> The intention is to merge Firebird 2 and
> Vulcan code back and create Firebird 3.
>
> Is this what's currently happening?
>
> Michael
>
>
--
~
>
> Kevin Stanton
>
> RDB Solutions
>
> P: 503-705-0834
>
> F: 503-822-0178
>
> [Non-text portions of this message have been removed]
>
>
>
--
Iwan Cahyadi Sugeng
Interaktif Cipta Lestari
[Non-text portions of this message have been removed]
Ahh.. good suggestion, i will keep that in mind, thanks
On Tue, Mar 6, 2012 at 3:09 PM, Mark Rotteveel wrote:
> **
>
>
> On Tue, 6 Mar 2012 09:33:19 +0700, Iwan Cahyadi Sugeng
> wrote:
> > What i wish for the security system is at least if we deliver our
> program
re quite different from a closed source system. But even with a closed
> source database that is not encrypted, a determined programmer can find the
> data in the file, given read access to it.
>
> Good luck,
>
> Ann
>
>
> [Non-text portions of this message have been
to
another sql server which we know the admin password. And one of database
system that can't be opened even if we move to another computer is
Access:D.
Iwan
On Mon, Mar 5, 2012 at 6:32 PM, marcelo.tropia wrote:
> **
>
>
> I am an experienced database administrator using DB2 on
ERTINTOemp (fruits)VALUES('mango')
>
> What is the analogous way to achieve this in Firebird (2.5) ?
>
> [Non-text portions of this message have been removed]
>
>
>
--
Iwan Cahyadi Sugeng
On 17 Aug 2011 14:10, "hvlad" wrote:
[Non-text portions of this message have been removed]
Hmm interesting info helen, so the embeded server will work mostly like the
super server.so what is the performance impact by using embeded server this
way.i meant if multiple apps accessing multiple or single database?thx
iwan
Iwan Cahyadi Sugeng
On 17 Aug 2011 06:52, "Helen Borrie&qu
Since you use embeded server,it will not be a problem running multiple
embeded server as long as you run it in a different folder. Fb 2.5 support
multiple connection to the database attached in embeded server. But i think
you should seperate each apps to its own folder
Iwan Cahyadi Sugeng
On 17
We al lknow that there is more than one John Smith in the world.
> >
> > Agreed. It can lead to some nice problems if you would enforce that.
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>
>
--
Iwan Cahyadi Sugeng
[Non-text portions of this message have been removed]
o,
>
> I think you may be right on the division by zero. Not sure what you mean by
>
> "use CASE to check before division".
>
> Could you please elaborate.
>
> Thanks,
> Mike
>
> --
Iwan Cahyadi Sugeng
[Non-text portions of this message have been removed]
Try upscene db expresss driver,so you don't have change anything,just
install the driver and use the specified dll file.there is another
driver,but i forgot,try googling
On 1 Aug 2011 17:46, "Maurizio P." wrote:
> Than you ,
>
> ... so it means that for delphi7 + firebird 2.5 i need a third party
ODE DESCRIPTION
> > Every Everyone
> > OT18 Older Than 18
> >
> > CLIENT_GROUPINGS
> > GROUPING_CODE CLIENT_CODE
> > Every John
> > Every Mary
> > OT18 John
> >
> > Required result when C.CLIENT_CODE = 'Mary'
> >
> > GROU
38 matches
Mail list logo