chart size limit

[conorn55]

Hi guys
So I have a table of data that automatically updates from a server, and a graph is generated from that table. However the table keeps on growing in size about 2000 entries, and I only need the most recent 100 or so to be graphed.
any help would be great.

Thanks in advance
Conor

 

[Legacy 143009]

You may limit your sql query like:

[COLOR=mediumblue][FONT=Consolas]SELECT[/FONT][/COLOR][COLOR=#000000][FONT=Consolas] * [/FONT][/COLOR][COLOR=mediumblue][FONT=Consolas]FROM[/FONT][/COLOR][COLOR=#000000][FONT=Consolas] Customers [/FONT][/COLOR][COLOR=mediumblue][FONT=Consolas]LIMIT[/FONT][/COLOR][COLOR=#000000][FONT=Consolas]100[/FONT][/COLOR]

 

[conorn55]

sorry not to sure how to do this?
i have used api queries to get my data