AuthorMessage
b_w_johan
Regular
Posts: 56

not sure if this would be the right place to start this topic, but my other options where php, vb.net or something about xml/plain text
i have the following:
MySQL database including names and addresses.
Excel document containing names, websites, accountdetails.
now i need to make the following:
interface for simply adding, removing and viewing items.
my question now is: export excel to MySQL ?
or drop the MySQL and work in plain tekstfiles like excelsheet or xml?
its like for php i rather use mysql, but in my vb.net i don't wanna make mysql connection if its not needed that much.
or any other ideas on howto combine those 2 to 1 file/database ? wich can be accesed by both php and vb.net taking lessed possible resources etc.
b_w_johan
Regular
Posts: 56

well if you are like WTF are you talking about
my actual questions would be:
whats best storage method: database or plaintext?
Whats simpelest to combine in both PHP and VB.net ?
Meka][Meka
Unstopable
Posts: 700

personally i would use mysql, simple because of the speed..... if you handle alot of data, then deffo mysql...
Meka][Meka
Unstopable
Posts: 700

Quoted from b_w_johan
well if you are like WTF are you talking about
my actual questions would be:
whats best storage method: database or plaintext?
Whats simpelest to combine in both PHP and VB.net ?

database is far quicker....
and tbh its easy to implement mysql into both......
b_w_johan
Regular
Posts: 56

haven't tried in VB.net yet ...
But i know its a mess with VB6
its needing odbc to be isntalled, and its slowing the computer down when youre messing arround in database with vb6
dzadzuks
Ametuar
Posts: 135

the speed for plaintext probably depends on your algo to find that needed item / parse
Meka][Meka
Unstopable
Posts: 700

Quoted from b_w_johan
haven't tried in VB.net yet ...
But i know its a mess with VB6
its needing odbc to be isntalled, and its slowing the computer down when youre messing arround in database with vb6

find a free component on the net.