8 replies to this topic

[Hamed]

Hello,
I want to know JSP database?
which DBMS is the best with JSP?
For example I use php/MySQL (mysql is good database for php)

Now I am using TomCat (XAMMP)

[wim DC]

Your database choice has nothing to do whether you use jsp or not. You write the Database access code in a normal class anyway.

It can be any database you want.

[Hamed]

Which DBMS is the fastest?

[wim DC]

ObjectDb :P
ObjectDB - Fast Object Database for Java with JPA/JDO support

Even though I think that's mainly for JPA use, and not if you want to do JDBC.

[Hamed]

Thanks,
But do you think it is really fast and can manage 10000 records?

wim DC said:

ObjectDb :P
ObjectDB - Fast Object Database for Java with JPA/JDO support

Even though I think that's mainly for JPA use, and not if you want to do JDBC.

[wim DC]

Databases can hold millions of records, if it can't manage 10 000 it shouldn't be calling itself a database ;)

I'm working on a table with 50 million records atm using mysql, queries don't take half a second as it should. You just have to think more about the queries you write when the amount of records gets big.
10k is rather small, so not much to worry about performance.

[Hamed]

Which version of MySQL do you use?
I want to make dictionary (Online web base) do you think JSP is good for me? or no I do it with php?
I really need speed because it is really important for me.
for simple search I will have 3-5 query which mysql can do it?

[wim DC]

I'm using mysql server 5.1 (should be the latest)
java server vs php benchmark
Shows that java uses more code, more memory, but results in less time required to perform tasks.

If you actually plan to get your site online. Beware the prices of java server hostings, they are usually more expensive than php ones.

Java is mostly used in enterprise environments. If all the site is going to do is look words up in the database and display its description java may be a bit 'too big'/overkill.
And in terms of performance for doing a simple lookup in a database and display the result, the difference between the 2 should not be that big.

Why will you need 3 to 5 queries for 1 search?

[Hamed]

My Queries :
1- 'SELECT' to find meaning of words
2- 'UPDATE' to update number of search for that word
3- 'INSERT' I use one API to find meaning after that I want to store that word and meaning of that.
4- 'INSERT' insert that word in user search table.
...

It look java is faster but php is cheaper.
Which language Google or Yahoo use??