List:Cluster« Previous MessageNext Message »
From:John David Duncan Date:June 1 2013 4:26pm
Subject:Re: LIMIT in NDB API
View as plain text  
Hi Mazen,

Using NDB API directly, you only get low level operations that you  
could use to implement LIMIT.  As you fetch rows in a scan  
(NdbScanOperation or NdbIndexScanOperation), you can count them, and  
then end the scan early when the limit is reached.

But if you use Java, ClusterJ gives you a LIMIT.

Or using JavaScript, mysql-js (which is under active development right  
now, to be released with MySQL Cluster 7.3) will also give you LIMIT.

Both the Java JavaScript APIs should be much easier to learn and use  
than the NDB API.

JD




On Jun 1, 2013, at 7:35 AM, Mazen Hajri wrote:

> Dear all,
>
>
>
> Is it possible to imitate the behavior of SQL's LIMIT in NDB C++ API?
>
>
>
> Kind regards,
>
>
>
>
>
>
> Mazen Alhajri
>
> Senior Software Engineer
>
>
>
> Futures Business Development
>
> P.O. Box 53870, Jeddah 21593
>
> 	
> +966-2-6615666   Ext: 106
>
> 	
> +966-5-35101980
>
> 	
> mhajri@stripped
>
> 	
> www.fbd.net
>
> 	
>
>
>
>
>
>
>
>
>
>
> CONFIDENTIALITY NOTICE - This email is intended for the sole use of  
> the
> intended recipient(s) and may contain confidential or privileged
> information. No one is authorized to copy or re-use this email or any
> information contained in it. If you are not the intended recipient, we
> request that you please notify us by reply email and destroy all  
> copies of
> the message and any attachments. Thank you for your kind cooperation.
>
> 	
>
>
>
>
>

Thread
LIMIT in NDB APIMazen Hajri1 Jun
  • Re: LIMIT in NDB APIJohn David Duncan1 Jun