table:
CREATE TABLE `avs` (
  `hashcode` smallint(5) unsigned NOT NULL auto_increment,
  `carrier` varchar(3) NOT NULL default '',
  `fltno` smallint(5) unsigned NOT NULL default '0',
  `identifier` char(1) NOT NULL default '',
  `fltdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `origairport` varchar(5) NOT NULL default '',
  `destairport` varchar(5) NOT NULL default '',
  `class` char(1) NOT NULL default '',
  `origpair` varchar(10) NOT NULL default '',
  `status` varchar(2) NOT NULL default '',
  `posting` datetime NOT NULL default '0000-00-00 00:00:00',
  `pollind` char(1) NOT NULL default '',
  `pstatus` int(10) unsigned NOT NULL default '0',
  `marketdefinition` varchar(3) NOT NULL default '',
  PRIMARY KEY  (`hashcode`,`carrier`,`fltno`,`identifier`,`fltdate`,`origairport`,`destairport`,`class`,`origpair`,`status`)
) ENGINE=NDB ;


query:
         "select class, " +
               "status, " +
               "origpair, " +
               "pstatus, " +
    		   "marketdefinition, " +
    		   "pollind " +
    		   "from avs where " +
    		   "hashcode = 1 " +
    		   "and identifier = ' ' " +
    		   "and carrier = ? " +
    		   "and fltno = ? " +
    		   "and origairport = ? " +
    		   "and destairport = ? "  +
    		   "and fltdate = ? " +
    		   "order by posting asc";



run in the parralell of 250 threads

there are 4.5 Mio records in the table
there are 2 apis per machine (4 totally)