I was recently make aware of an undocumented feature that's been in InterBase for more than 2 decades. It's the fact that every row in every table has a unique identifier. I think it is best thought of as a Raw Record position. This field is called RDB$DB_KEY. RDB$DB_KEY is an array of 16 bytes. Array's are handled differently with different drivers so you have to cautious about how you use this data type. However, RDB$DB_KEY provides the fastest access to uniquely identify a row in a table, so ...
I was recently make aware of an undocumented feature that's been in InterBase for more than 2 decades. It's the fact that every row in every table has a unique identifier. I think it is best thought of as a Raw Record position. This field is called RDB$DB_KEY. RDB$DB_KEY is an array of 16 bytes. Array's are handled differently with different drivers so you have to cautious about how you use this data type. However, RDB$DB_KEY provides the fastest access to uniquely identify a row in a table, so ...
I was recently asked by a customer for tips on making the fastest bulk insert. Here are my thoughts on the subject
Turn off inserts and check constraints. This one is by far the most important.
Perform a commit approximately every 10,000 rows. 10,000 is no absolute magic number, but is a good water mark.
Don't prepare every insert statement. It needs to be prepared just once.
Use the Batch API as discussed here: http://docwiki.embarcadero.com/InterBase/XE7/en/Using_Batch_Updates_to_Submit_...
In my recent CodeRage X talk I demonstrated many connection examples. I got thinking, how many different ones can I create that mean exactly the same thing? Here's a result of that thinking.
Let's assume you have InterBase server edition running on Windows. It could be any version of Windows. It could be any version of InterBase since InterBase 2009. It could be a 32 bit or 64 bit OS. It could be InterBase 64 bit server or InterBase 32 bit server. The name of your server is called Fred and IP A...
In my recent Coderage X talk I briefly discussed deploying InterBase client applications. I had way more content than I could talk about. Here is the information I wanted to present, but didn't have time for, or went over far to quickly for my liking.
First, a review on IBLite/IBToGo licensing, as that it is the thing that people trip up over the most. If you look at the order confirmation email you got when you bought Rad Studio, or information from maintenance portal if you got your product t...
In my recent CodeRage X talk I presented many examples of ODBC connectivity. However, there was a some more I wanted to say, but did not have time to do so. So, below is that content.
ODBC administrator has a 64 bit and 32 bit version on 64 bit versions of Windows. If you are using ODBC administrator from Control Panel, you are using the 64 bit version. To run the 32 bit version, you need to run c:\windows\syswow64\odbcad32.exe. The settings you make in the 64 bit or 32 bit version of ODBC ad...
This article is 99% a copy and paste from forums.embarcadero.com. You can see the complete thread it came from here: https://forums.embarcadero.com/thread.jspa?threadID=116587 Messages there don't live forever (looks like about 13 months max), so I am posting here so this elaborate post may live longer. The post was written by Jeff Overcash, who is a long time TeamB member and author of the InterBase Express (IBX) components included with Rad Studio.
What you see below is partially out of conte...
- Page :
- 1