Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-02 Thread Brian M
https://datatables.net/extensions/scroller/examples/ if you must have huge numbers of rows displayed. On Friday, December 2, 2016 at 2:25:14 PM UTC-6, Dave S wrote: > > On Friday, December 2, 2016 at 12:33:46 AM UTC-8, Gabor Nyul wrote: >> >> Brian, >> >> In fact this is already done. I have a

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-02 Thread Dave S
On Friday, December 2, 2016 at 12:33:46 AM UTC-8, Gabor Nyul wrote: > > Brian, > > In fact this is already done. I have a complete specification of each > report. > Just to give you an example: We are a railway company, having several > hundreds of train per day. There are a lots of

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-02 Thread Gabor Nyul
Brian, In fact this is already done. I have a complete specification of each report. Just to give you an example: We are a railway company, having several hundreds of train per day. There are a lots of modifications (above 60%, Don't ask why) to the original plan where we are assigning the

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Brian M
What Dave S. said is key > > "*If you had insight into what the users were looking for during their > examination of the data*, you may be able to provide a better query that > could *simplify the data presentation*." Sit down with your users and find out what it is that they *actually* need

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Dave S
On Thursday, December 1, 2016 at 11:08:18 AM UTC-8, Gabor Nyul wrote: > > First of all thanks for the hints. > So it means that the web2py's integrated grid will not be suitable for my > needs. Bad luck. :-( > Then here is a stupid and somehow provocative ( :-) ) question: What is > the value

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Willoughby
I like Python too but heck if you're that well versed in .NET I'd just do ASP.NET and use a nice grid: https://www.devexpress.com/Products/NET/Controls/ASP/Grid/ Done and done. On Thursday, December 1, 2016 at 2:08:18 PM UTC-5, Gabor Nyul wrote: > > First of all thanks for the hints. > So it

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Alex Glaros
Not a reporting tool, but as a tool to replace silo-oriented spreadsheet systems, web2py is the easiest-to-implement, best tool around. Hopefully it would not take much to build an example where web2py creates new value by virtue of integrating the data. Look for places to eliminate batch

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Gabor Nyul
This is exactly what I'm looking for. I do not want to Excel in that reporting circle. But to achieve this I need tools to help me. And those tools shouldn't give me and the team too much work compared to that Excel based reporting. That why I'm asking questions. 2016. december 1., csütörtök

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Alex Glaros
Unstructured spreadsheet processing is a world-wide problem. Consider creating a small prototype in web2py to replace the unstructured spreadsheet-based processes focused on demonstrating interoperability advantages. If there are data-quality/time improvements, and clearly articulated

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-12-01 Thread Gabor Nyul
First of all thanks for the hints. So it means that the web2py's integrated grid will not be suitable for my needs. Bad luck. :-( Then here is a stupid and somehow provocative ( :-) ) question: What is the value add of web2py (compared for example to flask or bottle) if in every case I have to

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-11-30 Thread Brian M
Can you use web2py for a reporting site - sure, a lot of what I do with it is reporting. I've been using DataTables.net which can provide pagination, sorting, search, aggregation and even basic export (via TableTools) for almost free. While it can enhance regular old HTML tables, with large

Re: [web2py] Re: Performance using MSSQL stored procedures

2016-11-30 Thread Gabor Nyul
Well, my users have as good as no computer literary, so the reports (lists) must be predefined for them. Theyhave just to enter some parameters (like date from, date to) Nd run the reports. That's why I'm looking for an easy way to present those lists to them. And of course, all the normal

[web2py] Re: Performance using MSSQL stored procedures

2016-11-30 Thread Alex Glaros
with so many reports, why not just put them in a reports generator? this way, clients could tweak or create new simple reports themselves without programmer http://blog.capterra.com/5-awesome-free-and-open-source-reporting-software-packages/ Alex Glaros -- Resources: - http://web2py.com -