Which language is best for writting CGI?

If you are using an NT server, you can use VB CGI. It is very fast and works well in the NT environment.  But, I reocmmend using ASP if you can in the NT environment.  It is quick and was designed to be easily implemented with thte IIS server.

How about in UNIX?
I want to get more information about this in UNIX server than in NT.

With as much documention as there is out there and as much free code (not to mention the support here) I would use perl with mSQL.

The "best" is hard to define.  So much depends on what you are trying to accomplish.

Here is my assessment:

First, the FASTEST way to accomplish any of this on NT Server with IIS is not with cgi but with ISAPI.  This pretty much requires either VC++ or VB but for high performance, you need it.

CGI, obviously can be done using any language that runs on NT Server, This includes PERL, C++, VB, Java, etc.  Perl is best for "quick & dirty" jobs although many huge web sites have been done with it.  It's biggest advantages are ease of programming and portability.  It's biggest drawback is performance and use of server resources.

VB and Java suffer from most of the same drawbacks as PERL.  Both are big and relatively slow although VB is getting better.

VC++ is probably the fastest method for cgi programs but at a cost of more difficult development.

phutson, can u tell me more about getting the information of Perl msql and where can i find the free code?

the instructions for getting perl can be gotten at perl.org can be aquired from
http://www.perl.com/pace/pub/perldocs/latest.html
perl is usually available on your host (I have yet to find one that doesn't have it)
mSQL can be found at
http://www.Hughes.com.au/

You can use any programming language that can write / read from STDIN. Why not use Unix/Linux with the Korn-Shell. If you want to access databases, you should use C(++)