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

Forum: ICE Engine Design Discussion

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

  1. 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: 8
    • Views: 2,550
    January 5th, 2017, 12:32 AM Go to last post
  2. 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: 7
    • Views: 2,686
    January 4th, 2017, 07:02 PM Go to last post
  3. Question Compression Ratio

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

    Started by a.srinivas‎, November 12th, 2013 11:56 PM
    2 Pages
    1 2
    • Replies: 13
    • Views: 4,651
    January 4th, 2017, 07:00 PM Go to last post
  4. 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: 6
    • Views: 3,877
    January 4th, 2017, 01:19 PM Go to last post
  5. 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: 16,429
    July 9th, 2015, 07:47 AM Go to last post
  6. 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,921
    May 26th, 2014, 08:41 PM Go to last post
  7. 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
  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,563
    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,931
    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,754
    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,480
    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,177
    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,289
    November 8th, 2012, 11:34 PM Go to last post
  14. 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,971
    September 11th, 2012, 06:58 AM Go to last post
  15. 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,413
    July 25th, 2012, 04:03 AM Go to last post
  16. 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,385
    June 22nd, 2012, 10:14 AM Go to last post
  17. 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,611
    May 8th, 2012, 01:13 PM Go to last post
  18. 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,262
    April 13th, 2012, 08:15 AM Go to last post
  19. How to separate brighthouse from infobright

    Hi all, I found the mysql is mixed with brighthouse closed and it is hard to separate mysql from infobright now, but I found the compilation...

    Started by boshiqian‎, February 20th, 2012 09:46 PM
    • Replies: 1
    • Views: 1,278
    February 21st, 2012, 12:49 PM Go to last post
  20. Simple query with join takes much longer than expected

    The following query takes about eight minutes to execute; select i.ADVERTISER_ID, i.CAMPAIGN_GROUP_ID, i.CAMPAIGN_ID, i.AUCTION_ID_64,...

    Started by jk1234‎, January 9th, 2012 11:35 AM
    • Replies: 7
    • Views: 1,537
    January 19th, 2012, 01:21 PM 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