Download3000 Blog

Hello,

Seems that post “Hibernate shortcut for XP” was quite popular and I was asked for same thing for Vista. So here it is…

1. Right click on desktop and select : New | shortcut
2. Dialog will appear… Type “shutdown /h” (without the quotes) and click Next.
3. Now you can enter the name for shortcut. An finally click finish

You can also change icon if you want so it will be more descriptive.

I’m a big fun of hibernate feature. It saves you a lot of time. If you are a fun too I’ll show you how to create a desktop shortcut for it and you’ll be able to access it even faster.

1. Right click on desktop and click New | Shortcut. Dialog will appear…
2. For location enter: rundll32.exe PowrProf.dll, SetSuspendState
3. Click next
4. Enter name of shortcut

You can also change icon if you want so it will be more descriptive.

If you use email you know how annoying SPAM can be. You can use various SPAM filters integrated to your email client but you’ll still receive less or more SPAM. I tried few of them myself including e.g. Spamihilator. It was quite good solution but I was still not able to eliminate all SPAM from my email box.

So what you can do ?

I found my answer in Gmail. As you may know Gmail has one of the best SPAM filters out there integrated. Why do not use it ?
Gmail has cool feature which ables you to download emails from other mailboxes to your Gmail account.
Here is how :

1. Login to your gmail account.
2. Click settings in right upper corner
3. Click Accounts tab
4. in “Get mail from other accounts” section you can see “Add another mail account” link
5. go through wizard (enter email and other account information)

Now Gmail will fetch new emails from your boxes via POP3 and will filter them.
This simple trick will eliminate more than 99% of SPAM from your emails… and best of all it’s Free.

When I’m downloading files I save them to folder c:\download. This already contains several hundred of files, mostly ZIP. The side effect of this is when you perform search over directory with big number of zipped archives it will slow down entire search process because windows is looking into zipped files. I usually just search for files that aren’t included in those zipped files so this functionality is unnecessary for me.

What you can do ?

Zip functionality in WinXp is handled by zipfldr.dll . This is dynamic link library located in your windows system32 folder. So you just have to unregister it from your system. How to ?

1. Click your “Start” button
2. Click “Run” from menu
3. Enter regsvr32 c:\winnt\\system32\zipfldr.dll /u or regsvr32 c:\windows\\system32\zipfldr.dll /u (The path depends on your windows installation)
4. Press “OK”

Run dialog

If you typed it correctly windows will unregister this DLL from your system and will inform you about this in message box.

Message box

Now.. if you want to enable ZIP support you’ll have to do it same way just type:

regsvr32 c:\winnt\\system32\zipfldr.dll or regsvr32 c:\windows\\system32\zipfldr.dll
(Again: The path depends on your windows installation !)

Question:

Do you want me to create small utility that will do that for you automatically ? If so leave comment.

We would like to inform you that today we released the initial version of Free AVI to FLV converter 3000.

What is this application for ? It lets you convert AVI files to FLV (flash movie) that is used by video sharing sites (e.g. Youtube). Application is very easy to use and it contains several predefined profiles for output FLV file so you can simply set output quality.

You can download Free AVI to FLV converter 3000 here

We would like to inform you that initial version of Free FLV to iPod converter 3000 has been released.

What is this application for ? It lets you convert files downloaded from video sharing sites (e.g. Youtube) into Mp4 format that is iPod and iPhone compatible. Application is very easy to use and it contains several predefined profiles for both iPod and iPhone so you can simply set output quality.

You can download Free FLV to iPod converter 3000 here

We’re working on free video tools for you. They’ll include various freeware converters e.g. FLV to AVI and vice versa. Youtube becomes more and more popular so we decided to help you with your conversion needs. First tool (FLV to AVI converter) is almost ready and we’re testing it now.
Hope you’ll enjoy this stuff and your comments will be appreciated.

I decided to write this post during development of new Download3000 site engine because I think it is the thing that many developers simply forgot to consider when they develop new applications based on MySQL database server.

If you run a busy site, MySQL query cache is a must. It can dramatically decrease server load and save system resources for other services you run on the same server.
When it comes to cache size, small sites can use values under 32MB but if your site is really busy (tens of thousands page views a day) and you use big number of different applications you can set higher value. You can set it to 64MB or go ever higher to e.g. 128MB. Of course it depends not only on your requirements but also how much RAM you have installed on server and you must consider also what other services you run on same machine. You simply cannot dedicate all RAM to MySQL if your server is running also Apache.

And now why I wrote this post…
Developers usually forget to keep query variations on low number. What does it mean ?
Here is a simple example… Let’s have a table with customers where we have these columns:
name, surname, number of orders, address
Consider we have two pages…

1. One is displaying information about customer orders, so we use SQL query:

SELECT name, surname, num_of_orders FROM customers WHERE customer_id = '1000'

2. Second is displaying information about customer, so we use SQL query:

SELECT name, surname, address FROM customers WHERE customer_id = '1000'

What will happen ? MySQL will run query #1 and store result set in query cache. Then for second page it’ll run query #2 and store result set in query cache. As you can see we have 2 duplicate columns stored in query cache: name, surname for the same customer_id = ‘1000′ . It’s overhead on for your MySQL server and you should avoid it if possible because it consumes space in your query cache.
MySQL is unable to think about queries, it just simply cache the results.

So what to do ? You should lower variability of queries if possible. I mean for our example you can use following query:

SELECT name, surname, num_of_orders,address FROM customers WHERE customer_id = '1000'

As you can see we store 4 columns in query cache now instead of 3 + 3 = 6 columns (if we use two separate non identical queries). So we saved 2 columns and it means we saved space in query cache that can be used for other query result sets.
This was a very simple example but if you run duplicate queries with large data sets (e.g. TEXT columns) it could save a huge amount of space in your query cache.

We’re pleased to announce Software Shop component for Joomla.

About:

Software shop is a component that allows you to integrate thousands of shareware products handled and distributed by RegNow.com into your Joomla site. If your visitors will buy software from your site you will earn commission (up to 75%). Just install component register yourself as a Regnow affiliate here: https://www.regnow.com/signup/affiliate and that’s all. Also… Don’t forget to add your affiliate ID into components parameters.

You can download it here

Enjoy…

Hello All,

We’re happy to inform you that we finally finished redesign of our site. Site runs on new engine. It was created from scratch and everything is smaller now. We decided to keep all CSS and XHTML standards.

And not just this… We moved Download3000 to new dedicated server. More power, more speed….

What does it mean for you ? You should experience faster page downloads and better browsing. So go ahead and try new download3000.com yourself. Every comment will be appreciated.