mySQL is a performance devil if you’re using it on your localhost or LAN. But using it on internet as a remote storage server is not mean the performance you got will performance you got in your localhost or LAN.

If you want me to sample it with an absolute ratio i can clearly say that if you’re getting 100% performance in your localhost or LAN you’ll get 15% performance while you’re connecting remote mySQL server over tcp/ip.

There is a one configuration that you can increase performance about 5 to 15 percent. That’s to disable name resolving on mySQL. You can do this by adding a line in your mySQL config (my.cnf or my.ini) after [mysqld] line (if you’re using mysqld standart daemon) : skip-name-resolve

You can test it if you want. This will make move your remote connection performance from 15% to 20 to 30%.

But infact this performance increasement will not fit your needs. It’s still so slow for me to use it. Thus please think twice if you’re willing to use mySQL as a remote database server for your client applications. ( Yeah but still it rocks on localhost or LAN )

You can check how mySQL uses DNS resolve from this document. ( Document mirror on focus on code (16KB) )

As you know full-text search means searching words on database. So how we understand (or find) a string is a word or not?

We have only one option to understand words. That’s the white spaces after words.

This can be a common problem if you save words on a column like these :

Read the rest of this entry »

In general most developers install Apache as a service to his/her machine. But sometimes only one apache server can not fit for our wishes. For example we want to use another apache server for testing purposes or want to use another apache server with different server configuration.

Have a nice day, here is how we do it :

Read the rest of this entry »

When using Zeos Database Objects you can encounter some problems about charset. The main charset problem will be that you’re using a charset different than latin1. In this case you can get some errors while showing or fetching data from mySQL.

We have a simple solution :

Read the rest of this entry »

If a field’s type is TEXT ( like LONGTEXT, MEDIUMTEXT etc) and we try to show it on a DBGrid it’ll be shown like (MEMO). But everyone in the world want to show some part of the TEXT field to user. For example you want to show user first 200 characters of the TEXT field.

To solve this situation;

Read the rest of this entry »

If you are using any OLE dedicated object (for example, if you’re parsing an xml document, there was a XMLDocument in your program, etc) and also if you’re using thread at the same time you can get some errors, mostly cache, ram errors. To solve this situation you must write;

CoInitialize(nil);

at your thread code before execute method. And after the thread function ends you must write;

CoUnInitialize;

By default local ip address is 127.0.0.1 or 10.1.1.1 or something like that. So when we’re using apache on our local machine and when we try to access our default server we simply type http://127.0.0.1 as our local address.

But sometimes we want to use different addresses. For example we want to use mod_rewrite to manage some url addresses but it’s not easy when we’re working lots of sites in our local server where they’re in more directories like these :

127.0.0.1/mysite1
127.0.0.1/mysite2
127.0.0.1/mysite3

And of course there’re another reaosons for that. For example you want to link your pages or styles or images dedicated to root like /image1.jpg but it won’t work on sub directories in our web server.

Reasons can be extensible.

Our solution will be simple…

Read the rest of this entry »

Sometimes working with sessions can be hard. But in fact all of those hardness comes from an unproper php.ini setup.

In this entry i’ll discuss about common session problems and of course the solutions.

Read the rest of this entry »

For some people it’s a hard job to configure their Windows machine using Apache for mod_rewrite. But in fact this is not a hard process.

Let’s check the steps together.

Read the rest of this entry »

Wordpress blog software saves so much domain related data to database. For example it saves blogs that have pinged your posts (as you consider you can ping your posts also) , your blog url, a lot of permalinks, guids, etc.

So, if you move your blog to another domain you must update all of those. Without updating them most of your links will fail (=gives 404)

I searched Wordpress database to those kind of data. After understanding the database i wrote five mySQL queries to solve this sitiuation.

Here is the five query you must execute at the new server (by phpmyadmin or shell) :

Read the rest of this entry »