Re: TimesTen and In Memory Databases.....

On Thu, 05 Mar 2009 14:36:19 -0800, Solomon_Man wrote:

Anyone had experience using Times Ten with very large Data Tables?

3. Users must optimize the Times Ten Database besides the Oracle
Database.
Most likely not a problem but still a learning curve.

4. No Procedure on the TimesTen Database at this point (release). This
is a major issue, in my opinion, is there ways around this?

What can I expect for speed improvements, 5X , 10X, 100X with Times Ten?

I understand the advantage of moving things into memory and avoiding
some of the I/O issues. Would I be better off adding an additional
processor or another rack then more memory instead of adding the
complexity of another piece of Software and machinery. Or even the
possibility of a data warehouse and update tables on X amount of time.

Opinions are welcome.

Thanks,
Chris

I have never used x10 but the idea of storing the entire huge tables in
memory prompted me to respond. I have done a similar trick with MySQL
which can create tables with ENGINE=Memory option. Basically, what you
do is to summarize your data mart tables by running queries with "GROUP
BY" and then load the results into the "DW engine", in your case x10, in
my case MySQL. BTW, MySQL can do client-server, there are lots of tools,
JDBC and ODBC drivers, as well as DBD & PDO. There is also a specialized
language for loading data into the database (any database, MySQL, Oracle
or PgSQL). It's called Practical Extraction and Reporting Language and it
is my sincerest advice to learn the language.



--
http://mgogala.freehostia.com
.

Relevant Pages

  • Re: Performance Issues of MySQL with Python
    ... Python and MySQL work together beautifully. ... other language for that matter) that calls a poorly ... designed database that gets terrible performance. ... to building a SQL query and passing it to the SQL ...
    (comp.lang.python)
  • Re: processing raw logs faster
    ... Well, that is precisely what he will get, unless he's using MySQL in the ... Being an Oracle DBA for 15+ years and working for large ... database speed is 25% of the ... MySQL is prone to lock escalation (many row locks are converted ...
    (comp.lang.php)
  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • Re: Oracle vs SQL Server
    ... In many cases, Oracle RDBMS was used to replace MS Access, an enormous overkill. ... PgSQL or MySQL can do that very well at the fraction of the cost. ... The polling scripts were being run simultaneously and the underlying MySQL database couldn't cope with 10 simultaneous transactions. ... Don't misunderestimate me, but I would check the SQL Server solution, too. ...
    (comp.databases.oracle.server)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)