Many people feel Sybase is unsuitable for large tables. How about a 25GB table?
I worked with a few post trading systems (commissions, trade-level revenues, settlement…), where each table’s data occupy 10 – 25GB, with another 10 – 25GB for all indices of that table. Each row is typically 1 – 2KB, typically within a Sybase data page, so such a table typically hold 10+ million rows.
My Sybase trainer said Sybase is faster than oracle/db2 for small tables below 100mil rows.
My database colleagues also feel Sybase is fast with 10-25GB/table.