Database Paging continued

I've updated my previous post with the actual implementation after testing and tweaking. The stored procedure for paging through threads in a forum from newest to oldest is quite different than my original post. The paging through posts in a thread is more like my original idea because it pages from oldest to newest. The forums are coming along nicely now. Once I finish with the MS SQL implementation it will be only a little extra work to get the MySQL version working so I can show it off on this site. This site is using MySQL but on my development machine I switch back and forth between the the 2 data layers as needed.

Comments

deebee

re: Database Paging continued

Wednesday, September 29, 2004 10:07:02 PM
Hi Joe I'm still reading the Developers Notebook. At the moment i'm testing gtk# but all on windows enviroment. I'm interested how your DAL is working. Any infos? Thanks deebee
deebee

re: Database Paging continued

Wednesday, September 29, 2004 10:12:11 PM
I'm planning an intranet extension of our ERP - Solution primary for internal use. I'm considerung to use OS because i start to really like it :-) Maybe I'll do it with mojoportal. Maybe you can give me insights into the code so that i can grasp the architecture. Btw. Keep on the good work. I'm still on fire!
Joe

re: Database Paging continued

Thursday, September 30, 2004 8:04:41 AM
Hi deebee, The data layer strategy is working well. On my development machine I can easily switch back and forth between the MS SQL and MySQL data layers using project references. Whenever I add a new feature I build the MS SQL first then the MySQL. It would be great if you want to use mojoportal for your project. I'm hoping to make a release within a month that will include the forums feature.
deebee

re: Database Paging continued

Thursday, September 30, 2004 10:22:56 PM
Hi Joe I think it would be a great + if modules for mojoportal will use NHibernate for persistence as well as your DAL. It's quite a OS standard on .NET and Java-side. I think i will test it with XSP after i finished the gtk# part of the book. btw. do you test on new mono (1.02)? I've readen in the blogs that they did performance improvements! great!
Joe

re: Database Paging continued

Friday, October 1, 2004 3:10:51 AM
I appreciate the suggestion deebee but I have no intention of adopting NHibernate or any other object relational mapping strategy at this time. I haven't seen anything that convinces me that approach is better than what I am currently doing. I have enough goals to keep me busy with this project and I have already tackled the data layer design to my satisfaction so I would rather work on new features than pursue alternatives to my current data layer. I do believe that the Rainbow Portal team is working toward an object relational mapping approach so they can support more databases. I will keep my on the outcome of their work but for now I see no reason for using that approach in this project. I'm still running mono 1.0 and finding it very stable as long as I'm using the MySQL data layer. I have also been following the blogs with interest and glad that they are improving performance. I will upgrade when I get the chance but again I want to focus my time on completing important features in the mojoportal framework.
Comments are closed on this post.