Hi all,
We currently have a Notes system and provide web interface for data exchange via XML. Everything seem to be fine.
But problems come when I am about to do a Dashboard. The thing is for Dashboard I only need Aggregate function like : average, total, sum…and ignore the whole row. Our sytem still read through the whole view which is extremely slow and unnecessary while we only require small bit of data. I cant get rid of it.
I figured out Web Services may boost up the process but not sure whether I can find any class in LS or Java so that I can send a SQL aggregate query and return as a service.
Any other suggestion is welcome.
Thank a lot guys