By: John Kaster
Abstract: Listen to the replay of the BDNradio broadcast of 8 hours on InterBase
Public chat room
This is the replay and chat room log of 8 hours of InterBase on BDNradio. The listen links provide a streaming WMA replay. The download links are in MP3 format, and can be either downloaded or listened to by click on them directly.
Introduction, Overview, State of InterBase
InterBase usage in Germany/Europe, and cool tools for Delphi and InterBase
Andreano Lanusse and Decio Moreira of Braspress
Braspress case study, log visualization, and Brasilian InterBase partner program
Rob Schieck and Jeff Overcash
Reliability and scalability of InterBase, IBX, case study
Tom Wilk of Logistics Health
InterBase UDFs, Linux, IBX, and DataSnap
Performance Analysis and Tuning in InterBase
Quinn Wildman and Gabe Goldfield
Maintenance, Support, and Installation
Sriram Balasubramanian, Charlie Caro, Shaunak Mistry
What's New in InterBase 7.5, future plans for InterBase, JDBC and other driver support
Understanding InterBase Transactions
The InterBase Borland Data Provider (BDP) and dbExpress driver
jkaster inserts the following link: http://qc.borland.comjkaster: QualityCentral URLjkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570jkaster: Agenda (always finalized at the last minute!) has been posted to EventCentraljkaster: jeff isn’t here yet, but you can submit a question to ask him laterjkaster: sorry, I mean he’s talking laterjkaster: since he’s here in the chat roomjkaster: just call me John ;)jkaster inserts the following link: http://test.borland.com/broadcast/default.aspxjkaster inserts the following link: http://www.danielmagin.de/interbaseradio/index.htmljkaster inserts the following link: http://www.cachetreff.de/cacheplz/main.aspx?plz=60439jkaster inserts the following link: http://blogs.borland.com/johnk/archive/2005/08/30.aspxjkaster:MartijnT: "John, thanks for the suggestion - still nothing. My list of "protocols" doesn’t list "MMS" either :-(" - sorry about that. keep trying, and also try the replays if you can’t get anywhere
jkaster inserts the following link: http://test.borland.com/broadcast/default.aspxjkaster: remember to register and click "I am listening" to be eligible for prizes and let us know you’re out there!jkaster: you can get automatically registered from your Borland USER cookie when you have logged in from BDN
jkaster inserts the following link: http://www.cacheatlas.de/jkaster inserts the following link: http://www.cachetreff.de/cacheplz/main.aspx?plz=60439jkaster inserts the following link: http://cc.borland.com/item.aspx?id=23629jkaster: New standalone version of IB Performance Monitor
jkaster: Craig just posted a new performance monitor to CodeCentral
jkaster inserts the following link: http://cc.borland.com/item.aspx?id=23629jkaster: (for those of you who may have just joined)
jkaster: Anders Melander, congratulations on your prize: "Grant Manager 3 for InterBase"jkaster inserts the following link: http://test.borland.com/broadcast/WinnersList.aspx
jkaster: welcome, andreano!andreano: This is BrasPressjkaster inserts the following link: tracking.braspress.com.br/myweb/index.html
jkaster:quinn: "The InterBase 7.x companion tools CD has a utility to pump data from MSSQL. I’ve never tried it though ..." - thanks Quinn
andreano: no wwwjkaster inserts the following link: http://images14.fotki.com/v205/photos/6/605301/2650041/bdnradio_ib-vi.jpg
jkaster: Congratulations Philippe Menoud for winning eDocEngine + PDFtoolkit Standard VCL Bundlejkaster inserts the following link: http://test.borland.com/broadcast/WinnersList.aspx
aohlsson: Jeff Overcashaohlsson: And Rob Schieckjkaster: lol. Rob will be talking toojkaster: agenda is posted here:jkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570
jkaster: unixguru, I was just joking. We know how Jeff likes to roam ;)jkaster: seems Rob has a bit of a connection issue for Skype ...jkaster: at least I’m guessing that’s the issuejkaster: are you able to hear him ok?jkaster: sorry ... we’ll boost him in the replay. he’s also cutting out a bit :(jkaster: Jeff is loud and clear, so the problem is boosting might distort him
jkaster inserts the following link: http://cc.borland.com/Author.aspx?ID=102jkaster: Jeff’s CodeCentral author page
jkaster:Melander: "Is cleaning up the IB Console GUI and making it consistent a priority? Do you need help? I’m embarrased to let my customers use IBC." - jeff: The primary thing going on right now is with Galen. We definitely want help.
jkaster:Melander: "Not a Q, but IMO what IB needs is a professional, quality GUI tool in-the-box. This is what the customer will judge IB by (GUI wise), not the quality of 3rd party tools." – agreed
jkaster: fuzari, see http://ec.borland.com/eventDisplay.faces?e=570 for links to audio and everything else, including agendajkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570
jkaster:boro: "I would like to test it and compare with our >200GB SQL Server DB... but not sure how to quicly move the existing data from SQL server to interbase" - jeff: There’s a data pump at upscene.com, and Data Junction ...
jkaster: also the old BDE data pumpjkaster inserts the following link: http://upscene.com/jkaster inserts the following link: http://www.clevercomponents.com/products/datapump/ibdatapump.asp
jkaster: dmagin: or free tool (ADO/BDE/ODBC sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and native Interbase on:jkaster:Melander: "What is Galen?" - jeff: You’ll find him in the newsgroups. You can email Jeff and contact him about it.
jkaster:jkaster: "What’s going on with the ODBC driver in 7.5.1?" - jeff: licensing ...jkaster inserts the following link: http://support.borland.com/entry!default.jspa?categoryID=157&externalID=2411&fromSearchPage=true
jkaster: From Quinn: Regarding BLR which Jeff has talked about, people might find the following interestingjkaster:albertrs: "Thumbs Up for Jeff !" - agreed!
jkaster:eWolverin: "What type of hardware? HP, Dell, IBM?" - tom: our hardware is Dell mostly. We have 4GB of RAM on our production server, Quad Xeon, Windows 2003
jkaster:eWolverin: "Do you have a disaster recovery plan with IB? How does IB make it easier to recover?" - tom: As everyone knows, IB does have very robust recoverability. To be honest, we don’t see a lot of crashes ... every time we have had a problem, we’ve been able to do an amend and get back to where we were before the crash.
jkaster: eWolverin, will keep your question for Quinn, ok?jkaster inserts the following link: http://cc.borland.com/Author.aspx?ID=4593
jkaster: Craig’s CodeCentral pagejkaster:quinn: "Craig - why don’t you put planalyzer in IBConsole?" - Craig: basically, because I’ve been trying to avoid working on IBConsole too much. (laughs)
jkaster:Melander: "Can something be done, in Planalyzer or IB, to make Planalyzer faster. Sometimes it’s extremely slow on complex queries." - craig: well, I’m changing the client application to not use DataSnap, which isn’t the ideal client for something like PLANalyzer. ...
jkaster:eWolverin: "How well does Planalyzer handle nested subqueries? I don’t use them, bug I have to debug them." - craig: That’s something it will represent. For nested queries, IB returns more than one plan.
jkaster:Melander: "One of the things I miss in IB/Planalyzer, compared to say MSSQL Query Analyzer, is the ability to get statistics on I/O and CPU cost. Also Query Analyzer’s plan graph is quite nice and easy to read." - craig: Let’s take them individually. I/O and CPU cost is something IB does not return. The plan graph does leave a little bit to be desired right now.
aohlsson: 8 seconds flat!aohlsson: :)aohlsson: The reason we have to run the streaming machine on batteries is that the power supply somehow feedbacks a whole bunch of noise (as you could hear for about 8 seconds there). Some day we’ll ask an audio expert what that’s all about. We’ve tried just about everything...
jkaster: or ask Dell why the interference happens ...
jkaster:dmagin: "to craig: can we have in future plan tool wich runs all sql statemts wich are stored in a txt file and write the plan. that’s good to analyse coplete application when we can export all sql’s." - craig: Any feature request for performance monitor should be put in for IB Console on QualityCentral.
jkaster: sorry, for PLANalyzer email craig directlyaohlsson inserts the following link: http://blogs.teamb.com/CraigStuntz/
aohlsson: Craig’s blog abovejkaster: PLANalyzer will be added to QC todayjkaster:Melander: "Snapshot: Like a gbak backup..." - craig: gbak runs in a snapshot transaction because it has to get the entire database in a consistent state. if a future version of IB does partial or incremental backup, this could become a much smaller issue.
jkaster: dpalley, use /ask to ask questions, or the ask link at the bottom of the browser windowjkaster:jkaster: "from dpalley: Regarding performance monitor, are there any plans to add server-wide monitoring instead of database-wide?" - craig: I have heard this might be coming available from the InterBase team, and I would love to do it once it’s possible.
jkaster inserts the following link: http://support.borland.comjkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570jkaster: Agenda is posted on EventCentral
jkaster:Kalle: "I can’t find the schedule for this broadcast. Does anyone know when it’ll be appropriate to ask licensing questions?" - when Michael Faisst is back on, or perhaps R&D
jkaster:Melander: "How come maintenance and support can’t be purchased online? You could at least list the prices." - quinn: software assurance is available online with the product purchase. with the premium and advantage support, those require a purchase order and a minimum or percentage.
jkaster:dmagin: "to gabe and also for var partners a complete silent install with registration (also for info)" - gabe: that’s for vars, they’ll have to contact Borland. You’ll get a superkey that overrides registration.
aohlsson:Kalle: "Please adjust the volume up a little for the two chaps." - They’re up as far as it can go without significant noise. We’ll adjust levels on the edited version when we post it.
jkaster:dmagin: "only for info: a lot of linux useres do no know there is also a text based install (if i rememeber)" - thanks for prompting the discussion, Daniel :D
jkaster inserts the following link: http://www.borland.com/downloads/download_interbase.html
jkaster:rcmagno: "ibx would like to know if the components irao to exist in proximas versions of delphi ?" - please clarify or restate this question. We don’t understand it, sorry.jkaster: thanks andreanojkaster: agenda has been extended and updated to bring Ramesh injkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570jkaster: sorry for the mix-up ... my fault!
jkaster wonders what Craig has done to ParamStr ...jkaster: Craig, I’ve always been impressed by you ;)
jkaster:Melander: "I’m seeing 100,000 context switches/S on a busy 4 way HT system with both v7.1 and 7.5.1. Is this normal, can anything be done about it (at my end) and does it matter?" - sri: What do you observe if you turn off hypethreading?
jkaster:eWolverin: "As Interbase becomes SMP aware, what about NUMA awareness?" - charlie: He’s talking about Non-Uniform Memory Access machines, and we don’t have anything in the plans to directly address this.
jkaster:dmagin: "for cahrlie caro later: can we have a debug switch in ibconfig to write in a txt file or temp table all sql. statments from clients fired up to the server?" - charlie: I can’t tell you how many times I have heard that, and there’s a lot of different ways to do that.
jkaster:eWolverin: "Sorry, I meant disaster recovery as in rebuild at another location. Quick install and restoration." - shaunak: we do have plans to facilitate this.
jkaster:eWolverin: "Did someone ask about simulating virtual instances, like in SQL Server?" - shaunak: When I looked at this question, I googled, and it looks more like a clustering kind of situation.
jkaster:Melander: "We discussed earlier that in order for Planalyzer to report optimization relevant information like I/O and CPU cost, IB needs to record and publish these statistics per statement. Any chance of this in the near future? Thoughts?" - sri: We have defiintely seen this request before. First we’re going to address scalability and performance of the server itself. We’ll look into this.
jkaster:RobJLove: "Any plans to support SQL Enhancements like SELECT * FROM (SELECT A,B FROM TBL) , or IF/CASE WHEN ?" - charlie: I have done some research on that, but it’s not something that’s real high on our customer agenda.
jkaster:overcash: "Any more thoughts on haveing insert statments return the RDB$DB_KEY generated by the insert?" - charlie: That kinda led into what I just explained. Rather than having new syntax, I think it would be pretty simple to use SQL to get the value back from that.
jkaster:overcash: "Any plans on a .NET manged gds32 client?" - shaunak: Ramesh and I have discussed this in the past. It’s something on the list. It might make sense to have something like this with an embedded version of IB.
jkaster:overcash: "Any chance of getting the ability to impersonate a user on a connection. IOW in a conncetion pool the conenctions are established with a user, but from a trigger standpoint I’d want the USER variable to return the impersonated user." - shaunak: We haven’t really thought about this so we don’t really have a plan for something along these lines, but we can see the need. Good request.
jkaster:overcash: "Can we please get direct update of blob fields with strings without the need to go through paramters?" - charlie: That is one of the things that was on our original laundry list to do for 7.5
jkaster:overcash: "Charlie als once talked about insert into .. returning values <cols>" - charlie: again, I don’t see a need to come up with a syntax like that. I would use a virtual table
aohlsson thinks that smoking is like COM. Don’t do it. ;)jkaste thinks Lino says that, too! :Paohlsson: I just had to paraphrase Lino Tadros... :)
jkaster: .. "haven’t started ..."jkaster: Rudy should add it to his signatures
jkaster inserts the following link: http://research.microsoft.com/pubs/ccontrol/jkaster: a link for a free (but old) book on concurrency control theory from MS.
jkaster inserts the following link: http://support.borland.com/category.jspa?categoryID=154jkaster: Quinn says: Note that a few fields in tmp$ tables didn’t make it into the docs. They are documented in the knowledgebase. See the above URL.
jkaster: is there a QC # for this?
jkaster inserts the following link: http://ec.borland.com/eventDisplay.faces?e=570jkaster: This InterBase BDNradio broadcast links and agenda
jkaster inserts the following link: http://test.borland.com/broadcastjkaster: BDNradio broadcast listener application
jkaster inserts the following link: http://test.borland.com/broadcast/WinnersList.aspxjkaster: BDNradio broadcast prize winners
jkaster: we’ve got a 2-3 minute delay on the stream folks, just so you know. things might appear on the chat faster than the audiojkaster: Melander, :D
jkaster:Kalle: "How do I submit a quite long question to Michael Faisst?" - You can email him at michael dot faisst at borland.com
jkaster: bedtime for me, too!jkaster:Kalle: "Ok, will he be able to answer it in this broadcast?" - if you email him NOW, he may see it in time. cc me and Anders. same email pattern, or just use "johnk" at borland.com for me
jkaster: Michael Faisst is one of the 2 product managers for InterBasejkaster: Joe Overton is the other one, and he is on the road today
jkaster: how about managed code stored procedures and functions?jkaster: like JDS has?jkaster: .NET and Javajkaster: Shouldjkaster: NDataStore prototype supports .NET on full and CFjkaster: PlanAnalyzer is now available in QC under Graphical tools IBConsolejkaster: new QC node isn’t showing up on QC web client yet, so I’ll have to inject the URL later
jkaster inserts the following link: http://qc.borland.com/wc/qcmain.aspx?da=24126
jkaster: At BorCon last year, we demonstrated (me, even) debugging Delphi stored procs with NDataStore
jkaster: MTonies, use /ask to ask questions or make suggestions for feedback from Ramesh
jkaster inserts the following link: http://bdn.borland.com/article/0,1410,32714,00.htmljkaster: BDNtv on Data Remoting
jkaster inserts the following link: http://bdn.borland.com/article/0,1410,32917,00.htmljkaster: BDNradio with Ramesh on Data Remoting
jkaster inserts the following link: http://bdn.borland.com/article/0,1410,32718,00.htmljkaster: In depth article on Data Remoting by Jason Vokes
jkaster:MTonies: "Ramesh, will a future version of dbExpress have a way to pass custom parameters to the driver? Eg TSQLConnection.Parameter strings not recognized by the components?" - ramesh: There is an option for this in (probably) the next release with a key/value pair
jkaster:MTonies: "Ramesh, will there be complete documentation on writing a driver? eg: what should each function do exactly? How does the transaction management work? Etc?" - ramesh: This is a common request we get quite often. We haven’t been able to spend time getting these specifications out. There are several 3P drivers out for DBExpress, and an article is already on BDN.
jkaster inserts the following link: http://bdn.borland.com/borcon2004/article/0,1944,32121,00.htmljkaster: Technical Overview of InterBase 7.5, by Charlie Caro
jkaster inserts the following link: http://bdn.borland.com/borcon2004/article/0,1944,32102,00.htmljkaster: Enhancements to InterBase from 5.6 to 7.5, by Sriram Balasubramanian
jkaster:overcash: "What is the pricing plan for dual-core cpu’s. Hyper threaded is 1 CPU license for the 1 physical and 1 logical, but with dual core there are actualyl 2 physical." - michael: We’re not 100% final on this decision.
jkaster: look at slides on those sessionsjkaster:MTonies: "In addition to Stored procedures, will we finally get Stored Functions?" - michael: We have not explicitly called it out for the next release. It’s not high enough on the radar based on information from customers so far. Please let us know through QualityCentral what your enhancement requests are.
jkaster inserts the following link: http://qc.borland.comjkaster: QualityCentral home page
aohlsson: Oops... We’ll make him write the paper now... :)jkaster: or at least provide the slides!
aohlsson screams into the mike in an effort to wake up the other Anders...
aohlsson: Thanks guys. Over and out.jkaster: good night to some of you!aohlsson: Closing the room, so I’ll kick remaining users in a sec... :)
Welcome to the moderated Borland Community Chat!You are allowed to speak freely with everyone in this lower window. In the upper window you'll find all messages written by moderators and invited speakers. To submit a question, click on the ASK Button.dmagin: hi allRobJLove: hidmagin: do you have a connection to the live stream? is live stream (music) is still running?dmagin: i have no connectionRobJLove: I just connected to the live stream and it is not playing anything yet.RobJLove: But it is up!dmagin: yes it works (hello wa clear) but music is running verly lowdmagin: more volumedmagin: perfectdmagin: gonedmagin: interbase rocks!!!!!!!!!RobJLove: ah some music yes... All two of us listening ;-)dmagin: LOLdmagin: party, dancealbertrs: at least somebody here :-)dmagin:germany say helloalbertrs:catalonia alsodmagin: 1st was ok other to lowalbertrs: Great !RobJLove: nothing yet.RobJLove: lolRobJLove: I think I must have a proxy problem.ibexpet: here in germany sound i very good :-)NickB: Good here in New Zealand toodmagin: hi holger :-)RobJLove: Finally fixed.albertrs: Sorry... may I Ask when is Jeff Overcasch talking ?dmagin: jeff PDT: 0900 or GMT 1600albertrs: Thank you very much.albertrs: Jeff may I ask you a question.. ?dmagin: .albertrs: Thanks Mr. Kaster :-)albertrs: :-)dmagin: little confused the brasilian guys :-)albertrs: I really must say I am in Love with Interbase... honestly. :-)albertrs: It is robust... and "simple"albertrs: "simple" not meaning easy :-)dmagin: and is running running runningalbertrs: that’s it !!!albertrs: strong as a Monolith...boro: huh, maybe sending <Ask> my comment to the wrong place...boro: I would like to test interbase and compare it with SQL Server 2000/2005boro: but not sure how to move >200GB easily from Sql Server to interbase...albertrs: I never tested 200GB Databases..albertrs: but I have 100MB and 200MB databases working greatalbertrs: for years...dmagin: 200gb no probboro: I suppose (from specs) it does support GB DBsalbertrs: for me the point is the control I have with the data...albertrs: with IBX I feel like working with Paradox...albertrs: all under control.albertrs: greatalbertrs: I have developed many apps without a problem...CraigStun: Journey?boro: I have to concentrate on 1000s of users so transactions balancing / SMP is of very importance for usboro: how does IntB play with?boro: I read IntB vs MSSQL docs and it seems transaction support on IntB is superior then MSSQL one... (which easily locks the whole tables)boro: (which infact is on of our greatest problems)albertrs: That’s what happened to me when I had to decide between MSSQL and IBalbertrs: I had to devide between MSSQL 6.5 and IBalbertrs: at those times I found IB superior with the transaction support..albertrs: also Delphi Native components where superioralbertrs: to work with IB.albertrs: IBX in this case.albertrs: but my profile is quite different than yours..albertrs: I haven’t as many users as you...boro: yep... we have 4 Proc servers with 16GB RAM supporting whole regions with towsends of users on SQL serveralbertrs: uau.... :-)albertrs: that is billions of light years beyond my scopes :-)dmagin: http://www.danielmagin.de/interbaseradio/index.htmlboro: but is enough a whole table scan (millions of rows) to drag the whole DB downboro: in IB this should not be the case as it should be using different kind of tranactionsalbertrs: yes..albertrs: but..albertrs: I have done some tests...albertrs: as recursive SQL testalbertrs: I mean a select that select’s record from the same table..albertrs: select * from employee where EMP_ID = (SELECT *) ...IBExpert: for which kind of operation do you need a whole table scan?albertrs: and IB took ours to get something out...albertrs: (It is not for criticize)DaveN: hey billBillT: Hi DaveIBExpert: when you do select .... where xx=(select ....) you will always get slow answers because subquery is started for each record in main selectalbertrs: yes... I know..boro: whole table scan can be due to requesting ‘all items where updatedtime >= ... ) and this table has about 200M rowsalbertrs: I don’t want to compare as I am a IB Lover...dmagin: http://www.geocaching.com/faq/ )albertrs: but in MSSQL the same job tooks 30salbertrs: only that..albertrs: but there are rare cases where I had to use this.dmagin: http://www.cachetreff.de/cacheplz/main.aspx?plz=60439boro: so if there are other users hitting the DB they will be waiting for this transaction to be done ...boro: it can lead to our customers having DB timeout errors on web site...boro: which is a real problemIBExpert: is the 200m records the result because of a very old startdate as a param or is there just an index missing?IBExpert: Interbase gives you a very nice hint with the fetches value (shown in isql with set stats on or for example in ibexpert)boro: it is because dates within this field are so similar so index does not help at all and sql server starts with full table scan on itIBExpert: in such a case it sometimes helps to write parts of the datetime fields to redunant fields by triggers (for example extract fields for year, month, day and use the where clause on this field(s)dmagin: http://www.cacheatlas.de/IBExpert: we also made the experience on a 80M records table, that a second table with just the most used fields for the where clause helps a lot to speed up typical selects. we redesigned a table in this way, so that it was divided into 4 different tables and an updatable view was responsible for beeing compatible to the old structure. One table for pk and the most important fields, another table with pk and all other non blob fields, one more table with blobs for fulltextsearch and one more table with data from the original documents in rtf and txt format.dmagin: http://www.cachetreff.de/cacheplz/main.aspx?plz=60439IBExpert: ja, moin danielDaveN: welcome back to funky town, Robertdmagin: lolalbertrs: ganz gut gesprochen :-)RobJLove: Thanks. ;-)DaveN: An Australian band did an excellent cover of that songCraigStun: Skynyrd?venks: When is the session starting?DaveN: same to you :-PDaveN: soon venksMelander: When it’s ready... ?DaveN: heheMelander: How do I see a log of previous traffic? The "transcript" doesn’t seem to be working.RobJLove: You really don’t want to see it ;-)Melander: Now I *really* want to see itRobJLove: It might be posted later with the audio but I am unsure if it will be.RobJLove: Most of the time it has been just rambles of the listeners here <G>Melander: Nah, you’ve probably been badmouthing me.RobJLove: I would have to know more about you to do that.RobJLove: DaveN on the other hand ;-)Melander: Can’t you invent something? That’s what I usually do when I badmouth you :-)RobJLove: Nah false statments instead of random ones are much better.DaveN: eh? RobJLove: volume of speaker could be a bit higher? Since my audio has been bad what to others think?RobJLove: ah... loud!RobJLove: greatMelander: It’s OK nowCraigStun: New standalone version of IB Performance MonitorCraigStun inserts the following link: http://cc.borland.com/item.aspx?id=23629albertrs: now. sound is great in here.CraigStun: I’m running off to lunch now, please email me if it’s broken :)CraigStun runs off to a restaurantMelander: Woohoo. Now we just need a new Planalyzer...albertrs: good apetiteCraigStun: Coming soon, maybe this afternoon AndersMelander: Y0u da man!DaveN: mmmmmm food...dmagin: snap shot in interbase is a great featuredmagin: jkaster: multo apetitodmagin: jkaster: that the reason i like my home office (24h food)dmagin: lolovercash: Yea, but I’ve eaten at that Denny’s real late at night in the past (after a late night of QC work IIRC :)).DaveN: it’s 1.12am here and I can’t be bothered getting take-outalbertrs: I should be working...Melander brb albertrs: :-)Melander: Oh... Thanks. Brb 30 minutesDaveN: I should be sleeping..NickB: me too :P 3:45am hereDaveN: in fact.. I think I will...albertrs: your is worst DaveN :-)albertrs: I am goind to cinema...albertrs: watch maybe Mr. and Miss Smith.DaveN: saw that.. loved italbertrs: :-))))))))))))))albertrs: She is sooo gorgeus :-)Fernando: Hi ppalmerio...ppalmerio: Hippalmerio: which Fernando are you ? :)Fernando: from Toolppalmerio: ohh, excuse meboro: o.k. thanks!dmagin: daniel @ home: http://images14.fotki.com/v205/photos/6/605301/2650041/bdnradio_ib-vi.jpgalbertrs: Sorry... I lost connection... who is talking now ?albertrs: Thank you.unixguru: Maybe we can hear from Rob soon?andreano: about Reliability and scalability of InterBase, IBX, case studyalbertrs: please don’t take me wrongunixguru: Sorry, but Jeff rambles too much -- he did this at his BorCon session too.albertrs: but I would like to ask to Jeff if the SQL Editor on TIBDataSet will be let’s say betteralbertrs: yes :-)albertrs: great news..albertrs: I really appreciate your job with IBX..albertrs: the only annoying think is that the SQL Editor.albertrs: thanksunixguru: I’m not a shill, Jeff just has problems staying on topic when he talks.albertrs: volume is going down...albertrs: not very well...albertrs: i am losing sound...ib4: little more sound?albertrs: don’t worry...albertrs: I am just only trying to help :-)albertrs: For me is a great experiencie, chating, hearing all those borlanders...albertrs: greatdmagin: country check: me germanyCraigStun: Hello, DanNickB: New ZealandCraigStun: Dans, I guessalbertrs: me catalonia (spain)CraigStun: :)ppalmerio: Brazilalbertrs: new Zealand... wow... have you seen Smeagol around ? :-)Melander is backNickB: lol...he’s making me a cup of coffee at the moment ..... :)albertrs: :-)))))Melander: Yah!Melander: or rather: Yeah!dpalley: Hi Craigalbertrs: I visit this page EVERY DAY waiting for patches, new thinks :-)Fuzari: hello. This chat is only text?Melander: No, we can hear all you say... Try itFuzari: Ok. thanksMelander: I’m joking...delphiboy: who was the delphi team simulteanously consulting with? Microsoft?dmagin: or free tool (ADO/BDE/ODBC sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and native Interbase on: http://www.clevercomponents.com/products/datapump/ibdatapump.aspboro: I am looking for a fast way of doing multiple tables data importdmagin: the tool is really quickdmagin: try out is freeCraigStun: Galein is active in the IBConsole groupMelander: OK, thanksdpalley: What’s going on with the ODBC driver in 7.5.1?Melander: I just had to answer a phone call. Was there a msg for me?dmagin: who needs ‘old odbc’ ?? (sorry joking) you can find under: http://www.easysoft.com/products/data_access/odbc_interbase_driver/index.htmldmagin: odbc install from ib7.1 cd simple: install over splash screen application and the driver is licensed installeddpalley: No more updates from easysoft, I guess.dmagin: but odbc is slow and old styledpalley: I have quite a few Crystal issues with the current driver.albertrs: "Sorry to be a pest" ...but please Jeff.. let us press [RETURN] at the SQL Editoralbertrs: :-)dmagin: dpalley: I have quite a few Crystal issues with the current driver: perhaps change to Rave Reports which runs perfect with jeffs IBXdelphiboy: IBExpert does this pretty welldelphiboy: Good idea.. allows kicking the tires before buying... adds value to the productquinn: People should discuss the developer edition Michael Faisst is on at the end of showdelphiboy: Cross server joins?dmagin: incr. backups YEEEEEEEEEEESSSSSSSSSSSSquinn: Regarding BLR which Jeff has talked about, people might find the following interesting http://support.borland.com/entry!default.jspa?categoryID=157&externalID=2411&fromSearchPage=trueCraigStun: IB already works on a (Windows) cluster server. It would be nice to officially support that.dmagin: great!delphiboy: rubicon does that wellMelander: Officially. How is that different from the current way it works?delphiboy: an xml parser?CraigStun: Anders: Document it, maybe add support to the installer.CraigStun: Seems to me to be decent return for low effort.Melander: Document it, OK. Installer, hmmm. I’m not sure that it could be done so it’s actually usable in a production environment. I would prefer to configure it myself.CraigStun: I think the changes Rob mentions were 7.5 or 7.5.1, probably the latter.CraigStun: But we see more use of selectivity numbers even in 7.1CraigStun: I’m OK with just documentation WRT clusters.Melander: No it can’t.delphiboy: 64 bit???????????????delphiboy: when 64 bit????CraigStun: delphiboy: Ask Charlie Caro when he’s on.delphiboy: thanksdmagin: charlie os on air at 12:30 PDT 19:30 GMTovercash: what InterBase feature needs 64 bits? Even ORacle doesn’t have a 64 bit Windows DB (non Itanium).CraigStun: Jeff: >4 GB memory use.delphiboy: windoze??? who cares???CraigStun: You can do that w/out 64 bits, but it’s better with.delphiboy: 64 bit X seems to be the order of the daydpalley: Oracle has a 64-bit AMD64 version (beta)CraigStun: Also avoiding WOW would be good.overcash: Order of the day doesn’t mean that it has a real need.delphiboy: new servers out with 8 opterons and 128gbandreano: You can use >4GB without 64 bitdelphiboy: dual coreMelander: IMO >4GB ram would kill IB in its current architecturedpalley: I would settle for a 64-bit client for nowCraigStun: Yes, Andreano, please note that I did say that. :)Melander: I mean the overhead would kill itandreano: InterBase 7.5 increase(double) the page size and cache bufferovercash: I have a dualcore machine right now running IB 7.5.1 just fine.andreano: Hi Craig, good to see youdelphiboy: does it exploit the 64 bit data path?dmagin: andreano: you can see crag?? i can only read LOLCraigStun: Hi! I just released a new standalone IB Performance Monitor (see CC)albertrs: Jeff... only the last think (I know I am a pest...)overcash: The limit for 7.5.1 on page buffers is 2GB. This does not include the memory pools for statemetns, stored procedure triggers etc.andreano: yes, it’s mean read :o)albertrs: think about to let us press return at the SQL Editor PLSdmagin: btw: jeff thanx for your great informationsCraigStun inserts the following link: http://cc.borland.com/item.aspx?id=19494albertrs: I know It sounds silly but I use the SQL Editor a lot.. :-)overcash: Unfortunately I do not write the SQL Editor. I use the same one that all the DB compoentn use and that is written by another member of the Delphi team.overcash: I tend to reuse other peoples work if possible so I can concentrate on IBX itself.albertrs: Yes... I know.. the same as ADO..dmagin: hi tomalbertrs: but you said this would be change in DeXter or am I wrong ?albertrs: :-)overcash: In DeXter I’m going back from the custom one back to the standard one.albertrs: Ok...overcash: IOW, from one I wrote and maintained to one I don’t have to write and maintain.albertrs: let me say I appreciate your work...overcash: Thank you.dpolist: Hi folks!Melander: Anyone here has numbers on context switching in IB on SMP systems? I’m typically seeing up to 100,000/S on busy 4 way+HT systems and I think it’s a bit excessive.albertrs: Well I have to leave !albertrs: Great Job. Thank you Borland for all and have everybody I nice time.CraigStun: Anders, I don’t have numbers, but is that 7.1 or 7.5?CraigStun: 7.5 spinlocks on its waits, 7.1 doesn’t. Hence, switching should be lower.andreano: Hello Melander, we have many customer using IB in SMP ServerMelander: Both, 7.5 is better wrt context switching, but not that much.CraigStun: In that case I’d also suggest bringing it up when Charlie is on.Melander: kandreano: In Brazil we have a big case, using 130 users simultaneous, with 60GB, 7x24 a yearandreano: using InterBase 7.5Melander: I’m not questioning IB’s ability to run on SMP (all our IB customers do it), I’m just seeing an awfull lot of overhead.andreano: Ok, what the IB version your customer have been using?dmagin: cool 8cpus 8-)eWolverin: That’s excellent hardware.eWolverin: 8 cpus!!!eWolverin: 32 bit?Melander: Right now it’s mainly 7.1, a few 7.5.1. All are being upgraded to 7.5.1.andreano: This is good, there are some updates in InterBase Server Engine to work better in SMP Serverandreano: The MAX_THREADS in ib_config has important changes, what’s value in MAX_THREADSeWolverin: This is good info because I’m working with 8 CPU Itaniums.Melander: Hmmm. The default+1 I think.andreano: TLC enhances InterBase performance on SMP servers and single CPU servers when the IBCONFIG parameter MAX_THREADS is not equal to 1dmagin: my wordsdmagin: good adminandreano: That is, when multiple threads are allowed to execute concurrently inside the InterBase engine.andreano: If MAX_THREADS is equal to 1 then atom synchronization and TLC are both disabled.dmagin: wich udf?dmagin: nhok.udf?Melander: TLC? Also the value is never 1. It’s the default (I forget what it is) plus 1 (to work around the recent bug).andreano: Thread-private Latch Cache = TLC = this is new feature of IB 7.5.1andreano: The TLC reduces the number and frequency of atom synchronization locksMelander: Ah yes. Thanks.andreano: needed to safely address and pin down resident pages in the database page buffer cache.eWolverin: Those are some good reasons to stay with Interbase and not go with Firebird.dmagin: oh yes!dmagin: interbase -> borland -> quality -> great team!eWolverin: +quality supportteste: Great tean hahahahahahadmagin: and interbase users and interbase developers are ONE familyMelander is getting some chow. Brb...dmagin: great session: thanx tomCraigStun: Yes, very good!andreano: GreateWolverin: Very informative in a real work perspective.eWolverin: Good point about laptop deployment.eWolverin: thanks JK.CraigStun: I’m hoping for better segue music before my segment. :)CraigStun: Drat.dmagin: loleWolverin: same here, Craig!Melander is backeWolverin: Do you have links to some of the old research? I heard you talk about it in the 24-hrs of Delphi.eWolverin: Thanks Craig!eWolverin: Nice way to find out if you need an index or not.unixguru: IBPlanalyzer Rocks!!!eWolverin: cool!overcash: The cancel code is something I’m hoping to find time to also add to the WISQL window of IBConsole.unixguru: Jeff, that would be awesome!overcash: Now that the Plananyalizer is availaber in the source forge I can "borrow" instead of writting from scratch :).overcash: Excuse me, StarTeam, not SourceForge.unixguru: Jeff, we actually implemented that in our Delphi/IB application, it wasn’t bad.overcash: One thing I’m looking at is embedding canceling capabilities in IBX itself. What size effort that is going to be is the question.eWolverin: Good tip.Melander: Didn’t we try that when the feature was introduced in IB? It’s just a single method with a few lines of code...overcash: No I wronte wrapper code to test canceling around IBX, but what I’overcash: I’d do within IBX itself would be just background thread the call to execute_statement, but that would require that both the connection and the IBX component itself to understand that it is in a querying modeovercash: and not allow other activity until that thread complets or is canceled.overcash: The introduction os an asynchronous API in addition to the blocking API would be nice, but I don’t see that one happening. Melander: I think a Cancel method would be sufficient. Leave the threading to the user.unixguru: Agree with Melanderovercash: But you are only canceling a blocking call. Your main thread is frozen until the call returns. The cancel and the call would be happening in the same thread so you can’t effectively cancel.andreano: Melander, it’s if Jeff put the execution in thread, the developer will be have more benefits.unixguru: Just add a Cancel method that hides the ugly API call details -- rely on the programmer to understand that it needs to be in a separate thread.Melander agree with unixguruunixguru: if in the future you can handle the threading, great, but just the method would be useful immediately.overcash: I cancel API is available. But you pass it the statement handle, so I can’t embed it in the query itself becasue when you want to cancel if it was a method that component is in the process of a blockign call.unixguru: if in the future you can handle the threading, great, but just the method would be useful immediately.overcash: The problem is that to use a cancel method in TIBCustomDataset, I’d eitehr have to make the whole component 100% thread safe (so you can background thread the call but still call the method from a different thread) or O just background thread the actual long running blocking call and handle when the call is executing.Melander: Sure you can. Even if the query is busy in one thread. You can access the Handle from another thread. You could even protect it with a spinlock if you’re paranoid.Melander: oh you beat me to itovercash: It turns out that just background threading the call is a) less work and b) more efficient (making an IBCustomDataset thread safe at the component level will introduce overhead)unixguru: ok, get coding then ;-)overcash: I have looked at tthis enough to determine the general direction I want to go.overcash: Well for Highlander I’m looking at (in no particular order) Scripting the update SQL, new much improved memory model (yes I’ve talked about this for years), cancelable queries, TIBBatchMove completed, GDSLib (like MIDASLib)overcash: All some or none can always show up, but I’ve got some interesting things hoped for (and one I need to talk to R&D before I’d even consider talking about).dmagin: okovercash: I’ll add plan analyzer in QC today sometime.dpalley: Jeff, there’s a QC entry for a bug in TIBQuery when cancelling a queryRobJLove: It saved my back side ;-)overcash: Canceling from IBX or Canceling from ClientDatasets?dpalley: QC# 13107dpalley: I’m fetching data into a CDS via a providerovercash: I’ve looked at it, but I’m not going to address it in DeXter at this time. Unfortunately I have the fewest regression tests for CDS. Because of that I’m very careful about changes in the CDS code. One of hte reasno there are less new items in DeXter for IBX is I’m spending the time to flush out my unit tests.overcash: This makes it easier to make sure that changes don’t have adverse effects and I can do ‘bigger’ impact things with less risk.dpalley: Ok, thanks Jeffdpalley: Regarding performance monitor, are there any plans to add server-wide monitoring instead of database-wide?overcash: It doesn’t preclude me issuing a patch after DeXter with it, but right now I don’t think I’ll address this in DeXter proper.d3valerio: is there someone else here ?d3valerio: from brazil ?overcash: Yes, be careful using OnCalcFields on the CDS side of things :). Man does that thing fire a lot.andreano: Hi d3valeriod3valerio: hello andreano, i’ve just got into your yahoo groupd3valerio: thank youd3valerio: andreano, when did this start ?overcash: The latest IBConsole (and IBScript) now support ‘set statistics on index’ statemetns now.andreano: 09:00am Brazil hourdmagin: 20:30 in germanydmagin: thanx craig for your infosMelander: Yes thanks Craig. That was great.d3valerio: let’s take some coffee tood3valerio: = )d3valerio: everyboryd3valerio: everybody *d3valerio: = )dmagin: i spend the milkd3valerio: don’t worryovercash: Tell Gabe to speek up :).d3valerio: where does this conference take place ?overcash: It is hosted in San Jose [editor’s note: ScottsValley] at Borland’s campus.overcash: Speakers are world wide.d3valerio: thanksd3valerio: and where are you ?overcash: Me? AtlantaGa.overcash: And on occasion the TeamB guys have been known to help you too <vbg>.d3valerio: how do i speak in private mode ?dmagin: PDT1430 GMT2130 Michael FaisstCraigStun: Quinn, Anders Melander has posted some useful info on b.p.i.generalCraigStun: d3valerio, click the "Help" button.overcash: I don’t hide my email addresso n the newsgroups, but I do not give private help on issues.eWolverin: interesting...dmagin: it was not questions it was a infodmagin: :;-)dmagin: interbase downlaod: http://www.borland.com/downloads/download_interbase.htmldmagin: left registered usersdmagin: are the files later available to download as mp3 files??dmagin: loleWolverin: That install and registration feature is great.eWolverin: ...great.dmagin: no: give it to otherdmagin: ia am employee by better office and borland se in germany (so i am a partner and also in se team borland germany :-))Joelson: ...RobJLove: just waiting for the next session... it will be on soonRobJLove: At least I think ;-)Joelson: ????????RobJLove: Ramesh could not be found for his time slot so we have "dead" air (on music air) until the next session is on.RobJLove: Yeah!dmagin: TMP$Tables are greateWolverin: arrgh, no temp tables.dmagin: greatandreano: jkaster, the questions of rcmagno is "RCMagno would like to know what’s if there is plan for new components foR ibx in the featuredmagin: charlie, shaunak and sriram are really the heart of interbasedmagin: redirect and alias a really greatCraigStun is wondering what the heck is corrupting ParamStr....CraigStun: I dunno, it’s corrupt on the first line of the initiaization section of system.pas. If I’ve managed to corrupt it there I’m impressed with myself. :)overcash: Don’t forget you get default roles with EUA. Really nice feature to manage security for a great number of users.CraigStun: That comparison is out of date, but IB is still cheap. :)dmagin: IB gives you much more for the moneyrschieck: cheap and easydmagin: lolMelander: Turning HT off makes no differenceeWolverin: cool, this helps me target my markets.andreano: aeWolverin: I want it because I’m currently working with NUMA architectures.eWolverin: HP Superdomes.Melander: OKRobJLove: It would be nice if it was exposed with Turn on/off switch that dumpped to TMP$ tableRobJLove: that way PerMon and other tools could use it.overcash: The TMP$Tables, by default, are only readable by SYSDBA. You actualyl have to grant access to other people to see. If you are letting out your SYSDBA information, well I don’t think there is much you can do about security at that point in time.Melander: No don’t burden the database with it. IMO it should be sent to a trace tool somehow. RobJLove: But a TMP$Table would be secure.overcash: Something simular to events, were you register that you want to see them and the engine sends it to all registered clients?Melander: Jeff: Yes.RobJLove: So as a DBA I could log all sql statements hitting a database.. not just the long onse.overcash: You’d have to work out some sort of secruity scheme (it could jsut be a callback in hte admin API which has security requirements already), but I like the idea of registering and geting it then.Melander: For Windows, let Windows handle the security. For me security isn’t important because all our servers are secure and no users can get near anything important.overcash: The problem with it being in IBConfig (or anything in IBConfig in general) is that the server has to be restarted to take effect and then also restarted when you want to turn it off. It should be implemented more like the EUA through a column in RDB$DATABASE to enable and disable.RobJLove: One of my clients because of HIPAA could not allow that. RobJLove: Need to have anything that my list patient info it needs to be secure.Melander: All Windows IPC mechanisms has security built in. Isn’t that enough?eWolverin: IB installs so fast, a formalized technique would be a great selling point.eWolverin: Any New Orleans firm that needed to rebuild their app fast...eWolverin: in another city would be a great advantage.eWolverin: I did JK.RobJLove: Embeded IB on laptop for that client so the machines may not be configured secure enough.eWolverin: Yes, it is can be related to clustering, but not always.Melander: Rob: If you can secure the database file, you should be able to secure an IPC object.eWolverin: Virtual Instances in SQL Server allows you to take a server offline while allowing the instance to stay online.Droopy72: Derived tables?CraigStun: To be precise, I’d like a machine-parseable (XML!) PLAN, with cost per node, and I’d also like to be able to get the TMP$STATEMENTS info for an individual statement if I happen to have the statement handle (and it hasn’t been freed yet).andreano: InterBase support CASE, NULLIF, COALESCERobJLove: Oracle supports select from (select)Droopy72: That’s called derived tableRobJLove: ah, its nice feature that makes complex queries easier.CraigStun: Robert, that’s the problem. :)Droopy72: Yep, mostly when working with aggregatesCraigStun: INSERT statements can result in *lots* of inserted records!quinn: how about publishing client api?overcash: utter silence :)CraigStun: C++/CLI would make it a lot easier, I think.MTonies: yes, very!!MTonies: Did you check the recent QC entry on this?MTonies: QC #7997overcash: Hey, I asked for defrault roles and/or strings to blobs. I got the one I realyl wanted so can’t complain too much.MTonies: this particular QC entry also lists the SQL 2003 standard for direct binary updates...MTonies: A HEX string ... :)eWolverin: Thanks.dmagin: the team make a good job!!!!!!!!Melander is going for a cup of coffee and a smokeRobJLove: I remeber it something like: COM is like smoking... If you do it stop, if you have started don’t.RobJLove: yes oh yes.CraigStun: When I was on air I said I’d post a link for a free (but old) book on concurrency control theory from MS. Here it is:CraigStun inserts the following link: http://research.microsoft.com/pubs/ccontrol/
NickB: That was great Bill...I will be sure to download the recording to go over it all againquinn: Note that a few fields in tmp$ tables didn’t make it into the docs. They are documented in the knowledgebase. See http://support.borland.com/category.jspa?categoryID=154MTonies: SQL 2005 will get this as well and will probably tout it as "new!"MTonies: Actually... MTonies: Are we getting them? :-)MTonies: IB 8.0 would be nice :)RobJLove: Yes a function can be used like this: select myfunc(field) from tableRobJLove: Don’t know if they will appear but I would like them too.MTonies: or "update mytable set field1 = myfunc(field2)MTonies: true trueDroopy72: and overloading the stored functionsMTonies: hmm... I dislike that :)MTonies: but functions in general, I would certainly vote for.andreano: Great job BillMTonies: Use them a lot [in Oracle]. And having to SELECT myoutputparam FROM myproc inside another select statement is rather annoying...MTonies: Yes, thanks BillDroopy72: the function ABS for example can be with more datatypesNickB: woohoo....thanks...that’s greatMTonies: Hmm, true. Perhaps something like "SQL Variant" would be useful then...MTonies: Or ABS should be moved inside the engine, then it could be solved, correct?MTonies: Or External Functions should be able to get a descriptor instead of a plain datatype...Melander: I’m buffering 60 seconds of the feed, so for me the audio will only be 1-2 minutes behind the chat now :-)MTonies: Hey, is that Anders?Melander: Oh wait. No It’ll be 3-4 minutes. Oh damned.Melander: Yep, that’s me.MTonies: Hello there :)Melander: Hi there yourselfMTonies: btw, any idea how many people are listening to this?Melander: Click the Userlist buttonMTonies: that’s the chat only :)Melander: Duh! I guess it’s bedtime for me soon.MTonies: same here ... pfff ...MTonies: John, forgive the newby ;) ... who actually is Michael Faisst?MTonies: aha, thxMTonies: Any news on what will be new in IB8? Or when it’s scheduled?quinn: Michael Faisst is a manager in the DPG (Deployment Products Group). One of the products he works on is InterBase.Melander: I’ve heard it will have a transaction log/point in time recovery... ;-)MTonies: oh oh ... *g*quinn: We are proving no specific information on new features or scheduling today. Various things have been talked about which are on the drawing board and may see the light of day in the future.MTonies: Stored Functions?MTonies: (push push)MTonies: I’ll start preparing a GUI for it... ;)MTonies: .NEt stuff?MTonies: might be useful... given that MS is doing it *g*MTonies: Would it work on Linux?MTonies: With Mono?overcash: PlanAnalyzer is now availalbe in QC under Graphical tools IBConsoleMTonies: Have you guys been looking at SQL 2005?MTonies: To see how .NEt stuff is supported there?Melander: Hey that’s great! So we’ll be able to write SPs in VB.net...Melander ducks MTonies: lolMTonies: From what I can see, you register a NET library and register each procedure/function with a normal CREATE PROCEDURE statement.MTonies: Would you do it the same way? Or anything else on the drawing board?Melander: Planalyzer: Wooohooo!overcash: I did test it with the windows GUI and it is now returned. It was actually there already, but not made public.MTonies: dbExpress should have a way to pass custom parameters to the driver :)MTonies: Done MTonies: Now only for some real documentation on the interfaces and their exact purpose ;)MTonies: (I wrote a driver, it’s pretty tough to do, believe me)MTonies: yay!MTonies: Win32, I hope?MTonies: For dbExpress: it’s still a bit hard to test and see when which method gets called when and all (especially during design time)MTonies: Better documentation would be very very nice...MTonies: Good :)MTonies: ThanksDroopy72: The link doesn’t contain much data?Droopy72: I meant those from Charlie Caro and SriramMTonies: any new SQL examples?MTonies: lolDroopy72: On "http://bdn.borland.com/borcon2004/article/0,1944,32121,00.html" No Paper Received and No Files received. Am i missing something?Droopy72: :-DMTonies: People, thanks!Melander falls asleep over the keyboard and accidentally hits JiUY5zG%[alt+F4]MTonies: :-)Melander: Gotta get some sleep. Good night folks!MTonies: bye bye AndersMelander wakes up, falls of the chair and smacks hit head into the power buttonMTonies: yeah, and it’s bloody late here ;)fdweller: Bill is in Az.Droopy72: Thanks allquinn: Bill is in Arizona I believe ..MTonies: Thank you all ... Looking forward to the new version of InterBaseNickB: Thanks guys...really enjoyed this broadcastMTonies is leaving and going to bed ...MTonies: right back at ya ;)andreano: Thank you guys for the invite and let’s go InterBaseNickB: Bye allDroopy72: Bye
Trial Download Week!
Click here to download a free 30-day trial of InterBase XE3 Server or ToGo editions. Or download a free non-expiring Developer Edition >
More InterBase Info
InterBase XE3 Product Info
Free Developer Edition download
InterBase on Google+
Follow @InterBase_ on Twitter
Server Response from: ETNASC03