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:

<pre> 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]; </pre>