From Python to MySQL without passing through php
I made some changes in the code. Now the map maker directly connects to python. And directly stores the data to MySQL. I am not sure if it makes such a huge difference in terms of speed, but it surely it does in the complexity of the code and of the structure. Before I would read the data in php, store it as a file, call the py program, write the result file from python. read the file from php and store it in mysql. A mess. Now it is all done through pyhton. This might also open the door toward the idea of running the program in background.
At the moment the speed of the mysql is the bottleneck of the whole service. Only people with few delicious bookmarks can have their map done. I don’t like this, and I have in mind a few ideas to solve this situation. The first one will just be to try to make the calculation run in background, so the user is not forced to keep a windo open the whole time. They might still be killed by DreamHost, though. So it is only moving the bar, not really solving the situation.
April 14th, 2007 at 8:19 am
Hi i have uploaded my delicious xml file. when i want to get the map your app says:
Parse error: syntax error, unexpected ‘.’ in /home/.booty/pietros/mindmymap.com/makemap.php on line 26
April 14th, 2007 at 1:36 pm
Yes, I saw, and fixed it.
Thanks for playing along.
Pietro