Absrd Home

Welcome to the absrd wiki! This tool takes advantage of parallel gcd and allows for for concurrent running sql queries. It also offers a lean object oriented wrapper to sql.

1. 1. Sample Show Off Code

Here we are creating 5 different query blocks. 1 of them query db called default and 4 of them query db called web1

Code as follows:

AbsrdQueryBlock block1 = ^(){ DbConnector *default_conn = [DbManager getConnector:@"default"];; NSMutableArray *res = [default_conn query:@"select * from courses limit 1"]; return res; };

    AbsrdQueryBlock block2 = ^(){

        DbConnector *web1_conn    = [DbManager getConnector:@"web1"];;

        NSMutableArray *res = [web1_conn query:@"select * from t_contents limit 1"];

        return res;

    };

    AbsrdQueryBlock block3 = ^(){

        DbConnector *web1_conn    = [DbManager getConnector:@"web1"];;

        NSMutableArray *res = [web1_conn query:@"select * from t_resources limit 1"];

        return res;

    AbsrdQueryBlock block4 = ^(){

        DbConnector *web1_conn    = [DbManager getConnector:@"web1"];;

        NSMutableArray *res = [web1_conn query:@"select * from t_activities limit 1"];

        return res;

   AbsrdQueryBlock block5 = ^(){

        DbConnector *web1_conn    = [DbManager getConnector:@"web1"];;

        NSMutableArray *res = [web1_conn query:@"select * from t_content_thumbnails limit 1"];

        return res;

    };

// Now we add these query blocks to the query blaster

    QueryBlockBuster *bb = [[QueryBlockBuster alloc] init];

    [bb addQueryBlock:block1];

    [bb addQueryBlock:block2];

    [bb addQueryBlock:block3];

    [bb addQueryBlock:block4];

    [bb addQueryBlock:block5];

// And now we execute all queries in 5 concurrent queries saving you a fracion of a time compared to // querying them sequentially

    NSMutableArray *result = [bb multiQueryParallel];