Blitz3d....streams and mysql....

-=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- (c) WidthPadding Industries 1987 0\|679\|0 -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=- -=+=-
Socoder -> Blitz -> Blitz3d....streams and mysql....
Wed, 11 Jun 2008, 16:42
Orion Pax	Ok! I have finally got the hole database/php/mysql/blitz thing worked out. I can now communicate with the database via blitz. But now I am having an issue with more than 1 query. In order for me to get it to work I have to open stream on port 80 to site. Then send my query to the php file. Wait for response. Close stream. Rinse and repeat. And doing it like this is taking a really long time. As there are 30 fields or more for each player record and I am attempting to load 100 players in one go. And it seems to be taking quite a while do like this. Should it work with on the same open stream continuously? Or do I have to keep opening and closing the stream?
Wed, 11 Jun 2008, 19:21
Orion Pax	Never mind. I figured out how to query for an entire row and make it comma delimited so I can seperate it after I get it all. Wasnt too hard. And it only takes 2 - 3 minutes to get 100 players worth of info. The old way would have taken several hours...lol.
Thu, 12 Jun 2008, 01:54
Mog	2-3 minutes per 100? odd... seems like it would be faster. I used my system for a large company database commit (250,000 users with over 3gb of data across 20+ tables) and it only took 2 hours (scoff if you may, people, but there was alot of data) Glad to hear that you are progressing Orion. -=-=- I am Busy Mongoose - My Website Dev PC: AMD 8150-FX, 16gb Ram, GeForce GTX 680 2gb Current Project: Pyroxene