frikkie6000
Expert Member
- Joined
- Nov 9, 2010
- Messages
- 1,043
- Reaction score
- 0
1
Last edited:
Only SQL Express has a size limit of 20gb
I am looking at doing a online reporting system in either asp or php both connected to their corresponding database SQL/ My SQL
Which option is better I am thinking that this could become quite large and My SQL is open source where I think (not sure) that SQL has a limit right of 10 Gig or something
Can someone shed some light on this for me which option is better and why you say so
Thanks
...I truly don't see the point in ASP.NET...
This has been my experience also, except that I haven't ever used SQLite but IMHO PostgreSQL is far superior to all other DBs, haven't compared it to Oracle or DB2 however.I read the opening post differently - sounds to me like you're asking about databases.
MySQL is open source, but was recently bought by Oracle (read what you will into that) - Oracle doesn't have the greatest record with open source apps.
If you're going big and want to stay open source, look at PostgreSQL. It kicks MySQL and MS-SQL's a$$ - Oracle's too. I mean it - this DB is quick.
If I had to go with one of your picks, it would depend on the platform. Windows, I'd still pick MS-SQL - 4GB (Express) is a lot of data. Otherwise MySQL would do the job.
Of course, there's always SQLite...![]()
Easier yes, Faster, maybe to develop yes. Faster operation however I doubt as Java is much faster than C# even on current benchmarks.ASP.Net is 10 times better than ASP, and that is enough. In my experience it's better than Java for web apps, too. Easier, faster... does that help?
(Yes, I know, it's Microsoft - but it's mostly shared source; enough so that Mono has been able to replicate it successfully. Who owns Java? Oracle. Starting to see a pattern here.)
We had a database on Oracle (huge - we're talking a massive cellular provider's call data) that we replicated on PostgreSQL. Oracle ran on a quad-core Sun server, PostGreSQL/FreeBSD on a PC. PostgreSQL ran a query in 5 seconds - the same query took several minutes on Oracle.This has been my experience also, except that I haven't ever used SQLite but IMHO PostgreSQL is far superior to all other DBs, haven't compared it to Oracle or DB2 however.
But I have been told (by some people that work at financial institutions)that there are situations where all DBs fail and DB2 keeps going, hard to verify considering the price tag.
Easier yes, Faster, maybe to develop yes. Faster operation however I doubt as Java is much faster than C# even on current benchmarks.
Also remember Java's target platform is Enterprise. There objectives are maintenance (or maintainable code), stability, horizontal scaling and performance. All of which you'll find are far superior on Java EE.
However I said I was biased. I've worked on both but just in terms of those objectives IMHO ASP.NET is just not on par.
Unfortunately you'll be hard pressed to find modern benchmarks of either so it is hard to confirm, I'll say this however, all large corporations in SA use Java EE (apart from MS obviously). IMHO for a reason.
This is also based on what I've learned, for example while I was still studying full time a guy from Absa came over to tell us about their IT operations and told us they ran on .NET which was completely unstable and thereafter they moved to Java EE (and obviously they still run Java EE)
Biased? Me too.I take it you worked on Java first? I worked on it second...
I'm reading loads on SAPsick
in here. Please stop that.
But back to what the OP asked: IMHO PHP is faster than .NET and easier also.
This just another religious war, by the way .Net is a framework uncomparable to PHP (a language) and it uses on code compilation and not interpretation like PHP. CS101 - checkout, "compiled vs interpreted languages".
Same to you! Need to catch you on Skype one evening soon though...Compliments of the season, dude.![]()
That's why I didn't voice my opinion either. Each platform will always have their die-hard followers, regardless of any objective views given by pretty much anyone. I do hate SAP though, but seeing as it's not really a development platform it can happily be excluded from any future platform-comparison threads.oh dear... not another one of these threads. I'll do my best not to post an opinion in here... we all know where that leads![]()
ze Germans vill not be pleased... :twisted:<snip>
I do hate SAP though...
</snip>
Oh dear. Germans might bring mention of Nazis or Hitler, so according to Godwin's Law this thread is now defunct.ze Germans vill not be pleased... :twisted:
I personally love developing in SAP.