How odd. I just dropped the table with the mySQL Workbench app, and it took over 20 seconds to get to the place where it confirmed if that was what I wanted to do!
I build my own SQL programmatically, and it looks like the following: CREATE TABLE `slylabs_Helpdesk`.`categories` ( `uniqueid` mediumint(3) unsigned zerofill NOT NULL auto_increment, `deleted` bit(1) NOT NULL DEFAULT 0, `sw_id` INTEGER NOT NULL, `sw_name` varchar(255) DEFAULT NULL, `sw_type` varchar(255) DEFAULT NULL, `sw_applies_to` varchar(255) DEFAULT NULL, `sw_find_conditions` varchar(255) DEFAULT NULL, `sw_condition` varchar(255) DEFAULT NULL, `sw_front_page` boolean DEFAULT NULL, `sw_position` integer DEFAULT NULL, `sw_counter_conditions` varchar(255), `sw_icon` varchar(255), `sw_built_in` boolean DEFAULT FALSE, `sw_live_update` boolean DEFAULT FALSE, `notes` blob NOT NULL, `signature` char(2) NOT NULL, PRIMARY KEY (`uniqueid`) ) At times it is pretty much instant and at times it takes a good long while. I was wondering if on-rev is locking the entire database at times, preventing any major SQL updates, or if the on-rev queue is very full at times and I am getting queue'd way down the list. Bob On Feb 1, 2010, at 2:48 PM, Jim Bufalini wrote: > Bob Sneidar wrote: > >> I thought I was having a problem with creating tables programmatically >> in my On-Rev database, but it appears that the table eventually gets >> created. It can just take 20 or 30 seconds to do! Is this normal?? > > Bob, it would be helpful if you tell us which DB you are using. ;-) If you > are creating your tables and accessing an SQLite or MySQL DB from a Rev CGI > or irev script it's pretty near instant (although with MySQL, I don't use > Rev to create the schema), so I can only speak to access. If you are > accessing direct from a desktop app rather than going through a server-side > script, then I don't know as I've never done it this way. And, I also > bought the MegaBundle but am just learning to sit in the Lotus position with > SQLYoga. ;-) > > Aloha from Hawaii, > > Jim Bufalini > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
