SQL database or Navision Database

panosj

Hello

The company that i work has Navision Attain and right now we are using navision with its own database database.fdb if i am correct.
Is it better to move it to an SQL Database? cause although we have changed server (Proliant with 2 GB ram etc) it is still going slowly..

Plz Advice

Navision attain ver 3.60

Waldo

Please give more information:

- Exact hardware of your server? (RAID, RAM, PROCESSOR, ...)
- How many users?
- How big is your database?
- Is your Network OK?

panosj

ML 530RG2 X2.8Ghz
2GB Ram
36Gb Raid0 --->OS 2003 Sindows Server
70Gb Raid5 ---> Navision Database

20 Users are using Navision
2GB navision Database

Waldo

please read this thread:

http://www.mibuso.com/forum/viewtopic.php?t=2102

panosj

Thanks in advance for the reply but i think that my question wasnt very clear....

Whats is better to use... Navision with its on database database.fdb?
or install on ANOTHER server the SQL Server and use it with the navision??


Thanks

Scott_Frappier

How many users concurrently connect to you database?
How large is your existing database?

tvandongen

What are your cache settings ?

Savatage

read the above thread from waldo. part of the navision hardware clearly states NEVER USE RAID5. It doesn't matter what type of database you use if your hardware is not set up correctly.

Waldo

... you also have to keep in mine ... when using SQL Server, you need a bigger, faster server than when you're using native db.