RE: Tsunami is this a good file for business applications? MySQL
- Posted by Ron Austin <ronaustin at alltel.net> Jan 22, 2004
- 464 views
sixs wrote: > > > Hello, > I am looking at Databases and downloaded the latest version of Tsunami > by Euman. I was wondering if anyone is using Tsunami? It sounds > strange with its page records, but I may be misunderstanding it. > I was reading about MYSQL version 5 .0 in eWeek magazine, Jan 12,2004 > and it's growth of 30% in 2003 vs Microsoft's SQL Server and Access > growth of 6%. > Any comments are appreciated. > Ben Duncan gave me some good comments on databases > Thanks to Ben and others > jvandal > > > I am using Euphoria and Tsunami to convert large unix-like application > to windows. The way I look at it is that the page size is just defining > a buffer area. For best performance the page size should be equal or > greater than the length of the largest record you will be using. I set > mine to a page size of 1K, which allows me to read and write records up > to 1KB long. Tsunami has very simple commands for reading and writing > records. You can have multiple indexes which are updated each time you add, update or delete a record. With a page size of 1K you can have 32 index segments. You can have a max of 128 index segments when you use a page size of 4 or more. An index is made up of one or more segments. For instance the first index could be made up of 1 segment - the Account Number. Index Two could be made up of two segments, the Last Name and the First Name. So far I have been making little programs to maintain various lookup tables. Soon I'll put them all together to make the main patient record program and then I will start using it in multi-user mode. I am very impressed with the speed of Tsunami and the way Euman has written the wrapper.