Enterprise Resources Planning(ERP SYSTEM) + MYSQL

2003-02-10 Thread yeong Tze En
I am trying to develop an ERP system(Enterprise Resources Planning).. I am wondering wheater if MYSQL suitable for this system..? Any opinion or suggestion from you all? Maybe Oracle or SQL server are more suitable.. at least the existing systems in the market are using this 2 type of

4 billion record + 6 Gigabytes text fie

2002-12-25 Thread yeong Tze En
My company is currently upgrade our company'database from PICK, an old database system to mysql.. Our company database got 1 table where the record is more than 40 million records, and the other table also got about i million record each.. what i found is i only can use the simple sql query