DBISAM is an excellent product, and my first choice for many situations, but be aware of the following:
Table indexes are critical for decent speed. Keep away from multiple joins with large tables. Indexes are Case-Sensitive by default - be careful if converting from BDE. Date format is ANSI i.e. yyyy-mm-dd All joined queries are canned - not directly updatable. Same goes for un-optimised queries - check case-sensitivity in WHERE clause expressions. It can be faster than BDE/Paradox in some circumstances but often takes a lot of SQL testing to get to that point, whereas the BDE seems to give good results no matter what you do with indexes etc. DBISAM support though is excellent. Steve > -----Original Message----- > From: Nahum Wild [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 12 December 2002 03:04 p.m. > To: Multiple recipients of list delphi > Subject: RE: [DUG]: DBISAM > > > That's pretty cool, I've never quite been able to use it > because of the lack > of one of these - third party reporting (eg, crystal) and the > like was never > possible. Now it comes down to is the ODBC implementation any good? > > Cheers, > Nahum. > > > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > wrote on > > > > there is an ODBC driver for the DBISAM that Elevate Software do...I > > saw it on their website. > > > > Jeremy > > > > -----Original Message----- > > From: "Bob Osborn" <[EMAIL PROTECTED]> > > To: Multiple recipients of list delphi <[EMAIL PROTECTED]> > > Date: Thu, 12 Dec 2002 14:31:30 +1300 > > Subject: Re: [DUG]: DBISAM > > > >> Can ADO connect to DBISAM? > >> > >> > >> Bob > >> > >> ----- Original Message ----- > >> From: "Tim Perry" <[EMAIL PROTECTED]> > >> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> > >> Sent: Thursday, December 12, 2002 1:48 PM > >> Subject: RE: [DUG]: DBISAM > >> > >> > >>> Hi Jeremy > >>> > >>> I have found DBISAM to work well, my only complaint is the lack of > >>> Referential Integrity in the engine. > >>> > >>> There are a lot of examples on Elevates web site, & the additional > >>> tools which Elevate supply are good. > >>> > >>> cheers Tim > >>> > >>>> -----Original Message----- > >>>> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED]]On > >>>> Behalf Of vss > >>>> Sent: Thursday, 12 December 2002 13:31 > >>>> To: Multiple recipients of list delphi > >>>> Subject: [DUG]: DBISAM > >>>> > >>>> > >>>> HI all. > >>>> For those of you who use DBISAM, what products are you using? > >>>> I am looking at a product that needs a database, and I > > dont want > >> the > >>>> hassel of distributing MDAC or the BDE etc. , when > > DBISAM is just > >> as > >>>> good for what I need. > >>>> > >>>> Thanks Jeremy > >>>> > >>>> p.s. I have looked at DBISAM by "Elevator Software" which seems > >>>> pretty good. IT supports most SQL statements that I need. > >>>> > >>>> > > ----------------------------------------------------------------- > >>>> ---------- > >>>> New Zealand Delphi Users group - Delphi List - > >>>> [EMAIL PROTECTED] Website: > >>>> http://www.delphi.org.nz To UnSub, send email to: > >>>> [EMAIL PROTECTED] with body of "unsubscribe delphi" > >>>> Web Archive at: > >> http://www.mail-archive.com/delphi%40delphi.org.nz/ > >>>> > >>>> > >>> > >>> > >> > > -------------------------------------------------------------- > > --------- > >> --- > >> - > >>> New Zealand Delphi Users group - Delphi List - > >>> [EMAIL PROTECTED] Website: > >>> http://www.delphi.org.nz To UnSub, send email to: > >>> [EMAIL PROTECTED] with body of "unsubscribe delphi" > >>> Web Archive at: > http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > > > -------------------------------------------------------------- > --------- > > ---- > > New Zealand Delphi Users group - Delphi List - > > [EMAIL PROTECTED] Website: > > http://www.delphi.org.nz To UnSub, send email to: > > [EMAIL PROTECTED] with body of "unsubscribe delphi" > > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > -------------------------------------------------------------- > ------------- > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > > -------------------------------------------------------------- > ------------- > New Zealand Delphi Users group - Delphi List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/2002 > > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
