Hi, I'd like to use SAPDB for small to medium data warehouse systems. I've been testing it and can't get it to work properly. Any help would be appreciated. Please correct me if I'm wrong. I'm running SAPDB 7.4 on my Win XP laptop. DB size began as one 2Gb file. I have 4 tables: Accounts, Products, Sales Reps, Time, and Sales. Sales has about 600,000 records in it, Accounts about 90,000, and Products about 500,000, Sales Reps about 60,000, Time about 50,000. AT first, any query with a join would run out of space. After reviewing the many messages on the space issue, I added another 2 Gb file to data. It still didn't work. I finally added more files, so there are 4 2 Gb files of data and 1 Gb file of log, and I added views that consist of only the identifier columns I need, so each record is not large. Now, I don't get the space error, but I am still unsuccessful in joining. When I joined the sales table to the time table to update the sales table with the appropriate time key based on the sale date, it did so in about an hour. I can live with that. But, when I try to join the sales table with one of the larger tables (like accounts), it kept running out of space. I am trying to update the sales table with the appropriate account key value by doing the following query:
UPDATE T_STG_SALES SET ACCT_KEY_CURR_1 = (SELECT A.ACCT_KEY_CURRENT FROM JOIN_ACCOUNTS A WHERE ACCT_ID_1 = A.ACCT_ID AND SALE_DATE BETWEEN A.ACCT_REC_BEGIN_DATE AND ACCT_REC_END_DATE) This query ran for 12 hours before I killed it. What scares me about SAPDB is that it appears to rewrite each table when a join is needed, and seems to need more than double the size of the data to do it. In a data warehouse situation, users often like to browse the data to determine what questions to ask. This browsing involves several joins on large tables. It appears to me that SAPDB will not allow this due to the extrordinarily long time it takes to cache each table for a join. If I'm understanding what's going on properly, SAPDB can not be used for data warehousing. I hope I'm wrong. Please advise. Maybe I'll try MySQL too. Joe Garrett Minnesota, USA -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
