On 11/30/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > On Nov 30, 2008, at 4:51 PM, Sheeri K. Cabral wrote: > > 3) I remain unconvinced this has to be done in the core microkernel. For >> the folks using LOAD DATA INFILE, how many actually need the performance? >> How many do it regularly, and why? For example, if a slave can have more >> than one master, does the need for LOAD DATA INFILE go away? What about >> some kind of Oracle->Drizzle plugin, or anyDB->Drizzle? Does that negate >> the need to run the LOAD DATA INFILE frequently? >> > > If the protocol connected up past the parser, this all would be very easy > to hook up. Even then though... reading directly from disk is still faster.
I'm guessing you mean "if the client protocol connected up past the server's query parser." While reading from disk is faster, my vision was "load in via CSV or whatever text-storage-engine, if CSV is extended to use other delimiters" and then ALTER TABLE ADD INDEX...., ENGINE=WhatYouReallyWant.....(or INSERT INTO RealTable SELECT (fld1,fld2...) FROM ImportTable). So "faster" for me would be relative to the whole process of getting the data exactly where I want it, not just "in the DBMS". That being said, is it possible to have an API to connect up past the parser, and then a utility tool could be used to quickly import data? And a fun question -- what positive ramifications could "really easy bulk loading" or even "API for connecting to the db past the parser" have on other things? ie, replication hacks..... In "random aside tangents", though, I'd love for there to be a plugin where >> something like LOAD DATA FROM [server] can set up a slave from a master with >> very little locking. >> > > How about a CLI to just clone a database? Sure, though having it be a command from inside Drizzle means that you can easily do something like STOP SLAVE; LOAD DATA FROM [server]; START SLAVE; and other such things. And that's under the "pony" section anyway. -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
