My company is moving towards SharePoint as a base ground for essentially an Enterprise System. Before we go into this (no one knows what capabilities or limitations SharePoint has) I had a few questions.
1) Is there limitations on applications that can be written for SharePoint? Things that you would normally be able to do in a stand alone app that SharePoint doesn't allow. (We will be almost exclusively web apps unless something necessary cannot be done there)
2) Is it possible to view real time data from a database in a presentable form (i.e. a pretty grid)? We've wanted to do something like this before and it was not possible with our current system, but it would be cool if we could.
3) We do a lot of reporting and are struggling with how much data is being pushed into a single string into a CSV (The rate is exponential and more than 5,000 rows is too much). Say we had a grid (I believe it's called a list in SharePoint) that the user could filter in an application, could that grid essentially be copied and pasted into and Excel sheet? We can develop a much better way when writing our own code to transfer data into a CSV, but I would like to know if it's possible out-of-box.
4) Side question; our browser applications in the system we have now have a very difficult time rendering grids. 150 rows takes a few seconds to show up (the queries are done almost instantaneously), have you had grids that have more rows than this in a browser environment and how much of a speed hit did you take if any? I'm essentially trying to figure out if it was a system issue or a fundamental browser issue.
Thanks for any information you can give us as we have been reading as much as we can, if you have any articles that explain specifically about application development for SharePoint please share.
EDIT: What kind of development time would be looking at for a single application? I know this varies A LOT, but say I wanted a simple application that you could see and filter data from a specific table, select a row, change and update it, as well as export capabilities to Excel. We've been in a rapid development system where this would take no more the 30 minutes for a single person, but could we achieve close to that in SharePoint development?