With my mad ASP skillz I can retrive and place infomarion in a Acess DataBase or in a simple text file. They both are just as easy for me to retrive and send informmation to. The question is which is faster? Which is better for the server? Which should I use more?
- aPaddedCell © Copyright 2006-2008 InterMedia. Site and all articles (unless otherwise specified) licensed under a Creative Commons License. Icons based upon the Tango icon set by various artists.
- All trademarks and copyrights on this page are owned by their respective owners. Forum posts are owned by the individual posters.
CptAwesome posted this at 02:04 — 14th March 2005.
He has: 370 posts
Joined: Dec 2004
Well, I don't think Access is a real SQL DB (though I could be wrong) so it's just semi plain text. If you get something like MSSQL or MySQL then that's faster and more secure. If you have an Access DB created, I'd use that because it probably automates the data input process more, and would make for cleaner code.
<? echo implode('',explode('|','A|W|E|S|O|M|E')); ?>
http://www.free-online-web-tools.com
bja888 posted this at 06:36 — 14th March 2005.
He has: 902 posts
Joined: Feb 2004
The only thing I know about SQL is.... you gotta make one string to retrive serten thing from a database. Other than that I dont know any thing about those 3 letters. Fill me in please.
Sites hub
Flash Portfolio
OptimalSource.biz
CptAwesome posted this at 06:46 — 14th March 2005.
He has: 370 posts
Joined: Dec 2004
SQL stands for Structured Query Language, and it's a database programming language. I think it takes a lot of the work out of the PHP/ASP programming by using smaller statements to gain information quicker. I could be wrong though. Always fun to read The Wikipedia Article on it
<? echo implode('',explode('|','A|W|E|S|O|M|E')); ?>
http://www.free-online-web-tools.com
bja888 posted this at 14:40 — 14th March 2005.
He has: 902 posts
Joined: Feb 2004
Ok so lets try this a diffrent way... I can write a SQL string to retrive infomation from a Acess database. Now how is that diffrent or simaler to useing MySql?
Sites hub
Flash Portfolio
OptimalSource.biz
CptAwesome posted this at 16:10 — 14th March 2005.
He has: 370 posts
Joined: Dec 2004
I've never really dealt with Access, so, it could be a full DB, but I'm not sure if the processor burden is on ASP (in your case) or if there is a background process running that is Access.
<? echo implode('',explode('|','A|W|E|S|O|M|E')); ?>
http://www.free-online-web-tools.com
openmind posted this at 19:01 — 14th March 2005.
He has: 945 posts
Joined: Aug 2001
TBH you shouldn't really use Access as a production database as its limited by concurrent connections and is not designed for web sites. MySQL is a much better method and using a tool such phpMyAdmin or MySQLFront, simple to manipulate...
nicora posted this at 20:02 — 14th March 2005.
He has: 263 posts
Joined: Nov 2001
any db will be more effective than a txt file. i agree with openmind that MySQL is your best bet.