VB.net MySQL DB Query - Developers

[QUOTE=Apple Pi;28438966]Guess I'll have to make a comparison chart showing speeds of direct MySQL and PHP MySQL.[/QUOTE] Indeed - Don't forget to take your ping into account though!

In VB are you establishing a connection every time you make a query? I wouldn't be surprised if that was slower!

[IMG]http://imgur.com/tCp90.gif[/IMG] I couldn't help myself.

VB app run on my computer, connecting to SQL server on a remote server PHP page run on the remote server and fetched via HTTP from VB. Selecting the same 10,000 rows from the same MySQL Database [IMG]http://i55.tinypic.com/14dkfia.png[/IMG] Now shut the fuck up. [editline]5th March 2011[/editline] Also, this doesn't take in to account the fact that the data coming from Connector/NET is already sorted in to tables and rows. The HTTP GET method is just a massive string which you'd have to parse and organise making it EVEN SLOWER.

Maybe I was wrong about the speed, but security is still a big problem.

[QUOTE=Apple Pi;28441253]Maybe I was wrong about the speed, but security is still a big problem.[/QUOTE] No you're wrong about that too. Although... I wouldn't trust the security of your code.

Apple Pi, care to explain to the viewers at home exactly which part of my experiment that proves you wrong is "dumb" ?

[QUOTE=CarlBooth;28441565]Apple Pi, care to explain to the viewers at home exactly which part of my experiment that proves you wrong is "dumb" ?[/QUOTE] The part where he's a moron. Ignore it I'm pretty sure everyone can figure it out.

I dont really know a lot about web programming, but is this man saying that its faster to access a php page on your webserver which then accesses your database, rather than just accessing your database without all the middlemessingaboutery?

[QUOTE=Icedshot;28441748]I dont really know a lot about web programming, but is this man saying that its faster to access a php page on your webserver which then accesses your database, rather than just accessing your database without all the middlemessingaboutery?[/QUOTE] That is quite exactly what he is saying.

[QUOTE=CarlBooth;28441565]Apple Pi, care to explain to the viewers at home exactly which part of my experiment that proves you wrong is "dumb" ?[/QUOTE] I rated you dumb because it pisses people like you off [editline]5th March 2011[/editline] :) [highlight](User was banned for this post ("Trolling" - BANNED USER))[/highlight]

[QUOTE=Apple Pi;28442422]I rated you dumb because it pisses people like you off[/QUOTE] :frog:

[QUOTE=mechanarchy;28446105]:frog:[/QUOTE] Ive never wanted to agree with a post harder

[QUOTE=Apple Pi;28442422]I rated you dumb because it pisses people like you off [editline]5th March 2011[/editline] :)[/QUOTE] I rated you dumb because your clearly a retard :)

Theoretically it might be faster to get a service running on the remote database server run the query and return results for you, but only if you're on a high-latency connection and the remote service has a very low overhead. A MySQL connection requires more data to-and-from to establish a connection (authentication, handshaking, etc). [editline]6th March 2011[/editline] The results are in! Using a remote service to talk to MySQL for you is [b]much[/b] faster over high-latency connections. [img]http://cl.ly/3N0O451W022n3i372N3l/content[/img] Here's the source for directmysql.js: [img]http://cl.ly/2k283o1y2P3I2r2y1z2w/content[/img] And remoteservice.js: [img]http://cl.ly/41071t1E1p0j3v041V0y/content[/img]

Well then.

We're talking about a host that is in the same room. So high latency doesn't apply.

If you were using memcached on the PHP page it would probably be faster regardless of the latency.

[code]with open("shit.file", "w") as storageNShit: for line in whatINeedToStore: storageNShit.write(line) print "Fuck MySQL. If I need security I can just encrypt this file."[/code]