Parameterizing Imports

Our command line import tool, irdbImports, provides a variety of methods for parameterizing your imports. Command Line Parameters First of all the command line parameters are available within the script as special variables, @param1, @param2, @param3 and so on, for each parameter. @param1 will generally be the name of the import script. A script called param.imp with the following contents.…

New Uncolumnized Import Mode

Before in IRDBImport, when you imported data, it would take whatever data was imported, and once the import statement was finished, it would columnize the result. If you imported a second or more tables with the same name, it would then uncolumnize the previous result, and append the new data. This is fine for a few tables, but if you are…

Improved Null Support

We recently overhauled InMemory.Net to add improved support for NULL operations. In general now we have added null support for most expressions. All functions should also accept null parameters, and return null if their parameters are null. You can also use cast with null, e.g. cast ( null as bigint ) to force a null of a specific type. MIN…

For those it may concern: the InMemory.net Feature list.

InMemory.Net Feature List Pure Dot Net In Memory Database Runs on Windows, Mac, Linux Easily Import data through ODBC/OLE DB/ Dot Net Data Drivers, through simple text scripts or via a Dot Net API. E.g. DATASOURCE a1=ODBC ‘dsn=your_DSN’ IMPORT sales=a1.sales SAVE 32 Bit / 64 Bit Odbc Drivers DISTINCT/MIN/MAX/SUM/AVG/COUNT/COUNT DISTINCT Support INNER / LEFT Join Support on multiple fields UNION…

New SQL Functions

We’ve added the following new SQL Function to the InMemory.Net database. Wanted to thank Jônatas Hudler for the suggestion. Substring(someString, startPos) Ascii(someChar) – Returns the ASCII code for a given char – or the first char, in case of a char array (string) Char(number) – Returns a char from an ASCII code Reverse(someString) – Reverse character positions of the given…

Performance Enhancements

We have deployed 2 changes that should improve performance in InMemory.Net Index Creation Indexes between tables should now be created at least 5 times faster than before. Constant Expression Refactory If you have an expression that involves multiple constants, or has constants involved in a series of functions, InMemory.Net will now evaluate that constant one time only, and avoid recalculating it…

Linux and Mac OS X Support

We recently released an updated version of InMemory.Net that runs on Mac OS C and Linux. Using the latest version of  Mono , we were able to get InMemory.Net up on these platforms. Currently we provide a zip of the relevant InMemory.Net files that can be extracted. The relevant InMemory.Net programs can then be run by prefixing mono before the name…

Case Studies:

Here are two case studies of previous clients that have benefited from InMemory.net: Homestore & More are an Irish based chain of stores selling a huge number of home and garden products. All this data was being run on an SQL server and their reporting might have taken them considerable amount of time with each query taking up to 30…

InMemory.net: the unveiling

Its been two years, a lot of caffeine, and finally we begin to officially unveil the new inmemory.net database. It works. Battletested with several existing clients, the new inmemory.net reporting database speeds up query times by an order of magnitude or more. Here’s the initial pitch: Inmemory.net delivers enterprise level speed at cost accessible to small and medium sized businesses.…

About InMemory.Net

Our technology, powered by Dot Net, extracts data via an ODBC, OLEDB or Dot Net Data Provider source into an In-Memory Database. Data is compressed by a factor of 5-10. Typically the extract is saved to disk, then loaded into memory for ultra-quick retrieval purposes. SQL queries are used to aggregate possibly hundreds of millions of rows in under a second.