SQL is built on top of ISAM (index sequential access methodology). Basically this strategy is fastest on look-ups overhead is thrown in to the insert side.
If you are inserting ungodly amounts of data quickly then you have to architect for that... such as tick by tick on all symbols. Advantage to SQL is relative ease & speed of data mining. You can also get tools that help with this. --- mikelaurataylor <[EMAIL PROTECTED]> wrote: > If you have a large amount of data you probably want > to go SQL since > it is probably fastest. I have access already on > my machine and > found linking to an access database with fairly easy > and it fast > enough for my database of 10000 or so records. > CSV and excel are > going to be slower because they are not databases > and not optimized > for this kind of work. > > --- In [email protected], "brian.z123" > <[EMAIL PROTECTED]> wrote: > > > > SQL database is the best ODBC Universal plugin > option? > > > > I have plans for the 'external' database feature. > > So far I have tried accessing CSV and Excel tables > from AB. > > CSV was sluggish and I couldn't get Xcel to work, > although I didn't > > try too hard on the Xcel. > > Tomasz/support recommended SQL as the better > option. > > I haven't tried SQL yet but it looks easy enough. > > > > Would anyone like to comment on the pluses/minuses > of SQL versus the > > rest? > > Would SQL have a speed advantage? > > > > I appreciate that it is not quite as universal as > MSFT programs > > although AB provided a free SQL link. > > > > http://www.mysql.com/ > > > > Thanks to everyone who is posting on the Access > topic. > > I still intend to learn how to use Access/Xcel as > well. > > My general computing skills are average so I am > very happy to be able > > to sit back and follow you guys or gals on this > stuff. > > > > BrianB2. > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Please note that this group is for discussion between users only. To get support from AmiBroker please send an e-mail directly to SUPPORT {at} amibroker.com For other support material please check also: http://www.amibroker.com/support.html Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/amibroker/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
