+ Post New Thread
Page 1 of 5 1 2 3 ... LastLast
Threads 1 to 20 of 98

Forum: ICE Engine Design Discussion

Discuss the ICE engine with our developers and the ICE community.

  1. Query Optimization

    Hello Team I am having query like which takes 10 sec to get data . is there any other way to rewrite query to get better result. select...

    Started by lalgourav‎, July 8th, 2015 11:40 PM
    • Replies: 1
    • Views: 15,783
    July 9th, 2015, 07:47 AM Go to last post
  2. Question Loading Data with Hibernate

    Hi! Infobright does not implement the SQL Insert statement. It uses other statements for data loading instead. See link below: ...

    Started by canicali‎, March 28th, 2015 04:58 PM
    hibernate, infobright, java, jdbc, load
    • Replies: 3
    • Views: 3,697
    March 31st, 2015, 08:35 AM Go to last post
  3. Loading data into infobright

    Hi, I am new to infobright and facing some problem with data loading using infobright data loader. I have installed infobright into my fedora...

    Started by 88manpreet‎, November 6th, 2013 07:02 PM
    data loading, infobright
    • Replies: 4
    • Views: 7,122
    January 5th, 2015, 05:56 AM Go to last post
  4. why do wanna keep fact and dimension table separate

    Hello All, I have gone through this link https://www.infobright.org/index.php/optimizing-infobright-schema/ but I did not understand why do we...

    Started by abh2001mah‎, May 26th, 2014 02:40 AM
    • Replies: 2
    • Views: 3,785
    May 26th, 2014, 08:41 PM Go to last post
  5. Moved: kernal: mysqld[2681] segfault at..........error 4 in mysqld

    Started by bcook@rez1.com‎, May 19th, 2014 01:25 PM
    • Replies: -
    • Views: -
    May 19th, 2014, 01:25 PM Go to last post
  6. Question Compression Ratio

    mysql> select count(*) from TEST; +----------+ | count(*)...

    Started by a.srinivas‎, November 12th, 2013 11:56 PM
    • Replies: 3
    • Views: 4,460
    March 7th, 2014, 10:21 AM Go to last post
  7. Comparision of MySQL standard and infobright (ICE) database engine

    Hello concerned, Recently I tried comparing the query times for MySQL and infobright database engines and found infobright engine to be much more...

    Started by 88manpreet‎, December 5th, 2013 04:39 AM
    • Replies: 1
    • Views: 4,866
    December 6th, 2013, 08:00 AM Go to last post
  8. Parallelization - ICE vs. IEE

    We're running a sharded solution on top of ICE in order to get past its limitation of single-threaded query processing. We're considering switching...

    Started by microx‎, October 7th, 2013 09:21 AM
    ice, iee, parallelization, performance
    • Replies: 4
    • Views: 7,274
    November 21st, 2013, 01:18 PM Go to last post
  9. Does ICE support log based CDC (Change Data Capture)?

    I would like to know if InfoBright's CE support log based CDC (Change Data Capture)? Does it support CDC at all? If this question is in the...

    Started by RTDS‎, October 10th, 2012 03:30 PM
    • Replies: 6
    • Views: 3,350
    November 13th, 2013, 10:26 PM Go to last post
  10. How to load json files using DLP into infobright

    Is it possible to load json files into infobright tables using DLP? If it is,how it can be done?

    Started by saipm‎, November 5th, 2013 08:04 AM
    • Replies: 1
    • Views: 1,662
    November 8th, 2013, 08:36 AM Go to last post

    I have two tables: object_properties and property_values with have 33M and 90M rows respectively. My data processing unit for parallel task are...

    Started by mich‎, November 25th, 2012 03:59 PM
    • Replies: 6
    • Views: 13,318
    June 1st, 2013, 03:29 AM Go to last post
  12. Designing column variable lenght

    Hi everyone, I'm just wondered if I IB is the right tool for what I'm trying to do. My design problem is to store huge amount of matrix...

    Started by jagudo‎, November 16th, 2012 12:50 PM
    • Replies: 5
    • Views: 2,074
    November 20th, 2012, 12:15 PM Go to last post
  13. What's the difference between DataPack and AttrPack?

    From the source of ICE, I found there are two classes, DataPack and AttrPack. What's the difference between those two classes? Thanks, Min

    Started by coderplay@gmail.com‎, November 8th, 2012 11:34 PM
    • Replies: 0
    • Views: 1,219
    November 8th, 2012, 11:34 PM Go to last post
  14. Distinct & Left join query crashes mysqld

    hi all! I'm using Infobright as DM,found a certain sql crash infobright down.I tracked the log and found some way to walk around it.wonder what...

    Started by vshanyiao‎, November 6th, 2012 01:38 AM
    • Replies: 6
    • Views: 2,513
    November 7th, 2012, 02:04 PM Go to last post
  15. Query by ID

    Hi, I have a table like this create table goods(id int, prp1 int, prp2 int, prp3 int, prp4 int, prp5 int); number of records ~100M. ...

    Started by originator‎, September 7th, 2012 06:19 PM
    • Replies: 4
    • Views: 1,750
    September 11th, 2012, 06:58 AM Go to last post
  16. Bug? LIMIT on LEFT JOIN and NULL

    version_comment: build number (revision)=IB_4.0.7_r16961_17249(ice) (static) I'm seeing a bug with SELECT statements using a LEFT JOIN and LIMIT...

    Started by yummysoup‎, July 24th, 2012 05:19 PM
    • Replies: 1
    • Views: 2,325
    July 25th, 2012, 04:03 AM Go to last post
  17. queary cash improve

    how to improve inforbright db sqls. when extract data volume form table taking more time. how to improve performace. on inforbrigt.

    Started by udara‎, June 20th, 2012 06:35 AM
    • Replies: 1
    • Views: 1,307
    June 22nd, 2012, 10:14 AM Go to last post
  18. inforbright data table move to mysql innodb or issam engine table.

    hi, I have mysql table whcih is on inforbright. need to convert into mysql innodb or ISAM table. how to do it. table are: # du -h...

    Started by udara‎, June 21st, 2012 11:58 PM
    • Replies: 2
    • Views: 2,046
    June 22nd, 2012, 10:04 AM Go to last post
  19. Parallel Processing

    I am running Infobright ICE on a Windows 2008 R2 Server on HyperV. Each morning I perform a dataload (app 3m records) which takes app. 20 mins. This...

    Started by jk1234‎, May 8th, 2012 08:23 AM
    • Replies: 2
    • Views: 1,521
    May 8th, 2012, 01:13 PM Go to last post
  20. Which level of transaction isolation does ICE support?

    hi, please reply. I use the following commands : select @@global.tx_isolation, @@tx_isolation;show engines; and I get some...

    Started by pxllele2011‎, December 22nd, 2011 03:29 AM
    • Replies: 3
    • Views: 2,173
    April 13th, 2012, 08:15 AM Go to last post


Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts