txt or DB?
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?
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.
bja888 (not verified) posted this at 06:36 — 14th March 2005.
They have: 5,633 posts
Joined: Jan 1970
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.
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
bja888 (not verified) posted this at 14:40 — 14th March 2005.
They have: 5,633 posts
Joined: Jan 1970
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?
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.
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: 267 posts
Joined: Nov 2001
any db will be more effective than a txt file. i agree with openmind that MySQL is your best bet.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.