Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Honestly I didnt even know how to give this topic a Headline so please don't hold it against me.
 
So here is my scenario, I have been a ASP.NET dev for a while and have lived in that comfort zone of SQL Server and C# or basically the MS universe denying the requirement that i would ever need to consider the LAMP solution.
 
So along came the day where i Began researching a idea and found that the cost of the MS universe is just plain rediculous hence i am now a PHP/MySQL Noob
 
Firstly i have never worked with data that would go beyond certain limits so it was always pretty straight forward development however my current project could potentially scale one day and hence meaning we would perhaps use MySQL master/slave solutions, MySQL Database Pooling, And lastly if it ever gets there Sharding.
 
Now since i am at the starting phase of development thinking ahead i am trying to forsee what we might encounter and reduce impacts and development changes etc.
 
So i have been debating the Store Procedure Route as should we ever scale and maybe shard do Stored Procs need to be customize to read from those different sources or will they automatically adjust with some miracle MySQL capabilities.
 
I have considered the ORM method for CRUD operations and Also the Procs Route for Our Reporting Aspects but i find it hard to know what side effects i will face with the stored procedure routes later on.
 
The Project will include Mobile. Will Require Continuous Searching as there will be a Search feature based on the information and there will also be Reports both Predefined and also Custom for the Clients to select what to compare on the Fly so what method would one suggest for this.?
 
Everyone i spoke to with a little knowledge and i also agree SQL procs Prevent injection and add a little speed benefit and reduce network traffic but is that really a gain as it could count against you at a later point in the game.
 
any assistance in this regard will be helpful thanks.
Posted 30-Jan-13 3:56am
Xenit7319
Comments
Sergey Alexandrovich Kryukov at 30-Jan-13 12:40pm
   
Very vague post, unsound question. Hard to see what help do you expect...
Perhaps, you need to use "Improve question", if you can.
 
One basic thing you need to understand: LAMP cannot have "principles", because this is nothing more than a package of instruments very often used together, so you need to consider PHP and other things separately.
 
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 CPallini 540
1 Sergey Alexandrovich Kryukov 420
2 George Jonsson 328
3 Pheonyx 218
4 OriginalGriff 215
0 OriginalGriff 4,813
1 CPallini 3,890
2 Sergey Alexandrovich Kryukov 3,274
3 George Jonsson 2,552
4 Gihan Liyanage 2,186


Advertise | Privacy | Mobile
Web02 | 2.8.140905.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100