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

Forum: ICE Engine Design Discussion

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

  1. Home UDF works fine on MyISAM and crashes Brighthouse table

    Hello I have a home made UDF with which I want to use to somehow replace the match .. against queries (so that would work without index but the...

    Started by eriam‎, October 4th, 2011 04:32 AM
    • Replies: 5
    • Views: 2,361
    March 17th, 2017, 07:41 PM Go to last post
  2. 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: 18,352
    July 9th, 2015, 07:47 AM Go to last post
  3. 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: 4,283
    May 26th, 2014, 08:41 PM Go to last post
  4. 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
  5. 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,939
    November 21st, 2013, 01:18 PM Go to last post
  6. 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: 4,726
    November 13th, 2013, 10:26 PM Go to last post
  7. 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,980
    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,739
    June 1st, 2013, 03:29 AM Go to last post
  9. 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,412
    November 20th, 2012, 12:15 PM Go to last post
  10. 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,499
    November 8th, 2012, 11:34 PM Go to last post
  11. 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: 2,293
    September 11th, 2012, 06:58 AM Go to last post
  12. 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,668
    July 25th, 2012, 04:03 AM Go to last post
  13. 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,454
    April 13th, 2012, 08:15 AM Go to last post
  14. 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,441
    February 21st, 2012, 12:49 PM Go to last post
  15. is ice support snapshot backup?

    hi, Can i use a snapshot to backup databases. I find that some snapshot backup use mysqladmin, mysqlhotcopy, mysqldump mysqlbinlog, these...

    Started by yao_knight‎, December 6th, 2011 01:58 AM
    • Replies: 4
    • Views: 1,607
    December 16th, 2011, 11:26 AM Go to last post
  16. I/O operation exception

    Error Messages is : Exception during sql named pipe use: I/O operation on /data/DBname/cfg_channel_program_dim.bht/TA00000000000000.ctb failed with...

    Started by yao_knight‎, November 25th, 2011 04:26 AM
    • Replies: 1
    • Views: 1,524
    November 25th, 2011, 12:33 PM Go to last post
  17. Convert vertical data

    I have a table that store a key=value reference of arbitrary data from my main records, and each record could have N number of key=values. How...

    Started by ernesto_vargas‎, November 9th, 2011 03:44 PM
    • Replies: 6
    • Views: 1,392
    November 10th, 2011, 09:27 AM Go to last post
  18. how to fix the issue "communications link failure"

    hi, I use Kettle as etl tools to load data to Infobright. But I am getting this exception frequently when i use "infobright loader", i hava...

    Started by yao_knight‎, October 16th, 2011 10:17 PM
    • Replies: 1
    • Views: 2,655
    October 20th, 2011, 06:04 PM Go to last post
  19. Infobright in memory

    I was wondering if anybody tried to run Infobright in memory. Taking under consideration that compression makes the database very small, why not...

    Started by C_George‎, October 18th, 2011 10:19 AM
    • Replies: 2
    • Views: 1,084
    October 20th, 2011, 05:52 PM Go to last post
  20. Query performance: should I break the table based on a column value for better performance?

    Hi, I have a table (raw_201109) with a number of columns, with one of the columns being a bigint "serial_int". Most of the queries do have the...

    Started by pbevara‎, September 21st, 2011 12:54 PM
    2 Pages
    1 2
    • Replies: 13
    • Views: 2,608
    October 7th, 2011, 08:56 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