Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Splitting a table into 2 tables...

Quote Reply
Splitting a table into 2 tables...
Hey everyone...I'd like to know if anyone can help or suggest what would be the easiest way to do the following:

I'm using DBManSQL and I have a table called guestbook that has 45,700 records and is about 11MB. There are 21 fields...2 of which are taking up 50% of the table size! I'd like to split the table into 2 tables...19 fields in one and the other 2 (plus a relational field) in the new table. I know how to accomplish the split, but how do I get DBManSQL to search on the correct table, and then pull all the fields for the record from both tables?

Basically my goal is to speed up searches by cutting the file size in half. Seems with DBManSQL, when more than one query is sent to MySQL, it slows down...if more than 3 queries are sent at the same time, it just seems to take a minute or more to return the results! I have 11 of the 21 fields indexed for speed! I optimize and sort the table with isamchk every 2-3 days! Nothing seems to help!

Any help or suggestions on splitting the tables would be appreciated.

AJ
Webmaster, TheFew.com
http://www.thefew.com
Semper Fi, Do or Die!
Subject Author Views Date
Thread Splitting a table into 2 tables... TheFew 1679 Aug 20, 2001, 12:16 AM
Post Re: Splitting a table into 2 tables...
tandat 1585 Aug 29, 2001, 12:16 AM