From: Syed Shahanavaz
Date: November 29 2012 11:02am
Subject: RE: NDB API Order by with Limit
List-Archive: http://lists.mysql.com/cluster/8455
Message-Id: <005e01cdce21$06965310$13c2f930$@fbd.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_005F_01CDCE3A.2BE4EAA0"

------=_NextPart_000_005F_01CDCE3A.2BE4EAA0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

 

Hi Johan,

 

Thanks for the reply.  Since I need perform something like example operation
using NDB API [Example: select * from tbltest where id1=1 order by id2 limit
5;].

Is it possible to do using for full table NDB scan!

 

Kindly let me know if you suggest any alternatives.

 

Best Regards,

SYED

 

 

From: Johan Andersson [mailto:johan@stripped] 
Sent: Thursday, November 29, 2012 1:10 PM
To: Syed Shahanavaz
Cc: cluster@stripped
Subject: Re: NDB API Order by with Limit

 

Hi,

 

Not that I am aware of.

NdbIndexScanOperation::readTuples(..) let's you order by index order , but
if you then want to sort it based on a particular column (if you are not
happy with the index order) you would have to do it yourself in the
application.

 

Best regards,

Johan

 

On Thu, Nov 29, 2012 at 10:16 AM, Syed Shahanavaz <sshahanavaz@stripped>
wrote:

Hi,



I am currently using NDB API for developing some web application.

I faced a specific requirement where results from NDB Index scan have to be
ordered ascending on a specific column and limit results to a specific
value.

Is there any way to order by on specific column in NDB API?



Best Regards,

SYED




 


------=_NextPart_000_005F_01CDCE3A.2BE4EAA0--