Re: Fulltext search -- no wildcards in phrases?

2003-04-01 Thread Shamit Verma
The replay on the webpage says that: "Nope. That would be a really slow search since mysql cant use any indexes and a table scan would be the only way to find it." Then even "LIKE" operator should suffer from the same performance drawback, how does LIKE operator work with in

Re: PL/SQL, Views, Functions, Proceedures

2003-04-01 Thread Shamit Verma
orked fine in the given situation. And fortunately, MS Access Driver is free of cost and included in most Windows installation. Regards, Shamit Verma http://www.vshamit.com - Original Message - From: "John Griffin" <[EMAIL PROTECTED]> To: "hemanth" <[EMAI

Re: what's the best format option for importing SQL Server databases?

2003-03-11 Thread Shamit Verma
CSV would be the easiest way. -Shamit Verma (http://vshamit.com) - Original Message - From: "kenn murrah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 1:54 AM Subject: what's the best format option for importing SQL Server databas

Re: MySQL & MacOS9

2003-02-12 Thread Shamit Verma
Hi, The approach I am suggesting is the one that you might use as a last resort. I do not know much about C/C++ programming in OS9. If you could find some ODBC Driver ( or any other API that can be used from C++ on OS9 ) that could talk to JDBC drivers, then you may connect to MySQL from JDBC, and

Re: Applications for creating reports for MySQL

2003-02-08 Thread Shamit Verma
Any ODBC compliant reporting tool should work with MySQL. Have you tried using Crytal Reports??? Regards, Shamit Verma - Original Message - From: "Octavian Rasnita" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, February 04, 2003 11

Re: Loading a database into RAM

2003-01-14 Thread Shamit Verma
You may try using a Ramdisk as storage for mysql "data" folder. Regards, Shamit http://www.vshamit.com - Original Message - From: "Steve Quezadas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 2:53 PM Subject: Loading a database into RAM > I have a mySQL da

Re: How to store maps in MySQL

2003-01-07 Thread Shamit Verma
Hello Jeremy, Thanks for the help. Regards, Shamit Verma - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Shamit Verma" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 12:42 PM Subject: Re: How to

How to store maps in MySQL

2003-01-06 Thread Shamit Verma
Hi List, I read that MySQL (4.1) now supports geometric data types. I tried to look for documentation related to geometric data types in mysql. But could not find any. Can someone point me to documentation of geometric data types? Thanks, Shamit Verma