Archive for the ‘Administration’ Category

Windows 7 aero lag fix

Friday, October 8th, 2010

Windows 7 is great, but on my machine every once in a while, like after a couple of hours of working, the interface starts to lag. Nothing big, probably just 100 milliseconds or something, but it is noticeable, and especially when watching movies. Don’t really know what it is exactly, maybe something with drivers or some program that slows it down, but there are numerous reports of this out there on the internet. And this thing is really annoying, because once it has started, EVERYTHING is lagging, all the windows and everything that happens on the screen.

This has nothing to do with too little memory or some process running in background. The lag would appear even when processor usage was on 0-5 percent.

So, basically, the workaround for this: once it starts to lag, switch a window with Windows+Tab button. (To open that 3D taskswitcher that came in Vista). Once you have done that, the lag is gone.

It is sure strange, seems like there is some bug that starts when something gets overrun, and the 3D task switcher resets it to make everything run normally again.

This isn’t really a fix, just a workaround, but searching the internets gave me nothing, and this solution is still viable. So here you go people, if somebody stumbles across this article with the same lag problem, there you have a solution.

Reliably importing huge mysql databases.

Thursday, August 5th, 2010

Every normal php web-developer will once in a while encounter a task of moving around mysql databases, or even individual tables. And if that database will be somewhat big, once again, the developer will have to deal with resource limitation problems like php execution time, memory, upload file size, and so on.

Luckily, there is a perfect solution: a php script that will import an .sql file of any size to a database, iterationally, thus automatically overcoming all of the resource limitation problems. Basically it runs itself many times, importing small portions of the file at a time, and you don’t even have to worry about that, just supply the database login info to the script, upload the .sql file to the server (by ftp for example), and press Import.
Plain and simple:
http://www.ozerov.de/bigdump.php

PS. Just remember: when you are exporting your files from the source database, uncheck the ”Extended inserts” option (in phpmyadmin or other tool), otherwise bigdump will not understand your file.