Hi Rahul-2 Now I established connection Mapguide studio 2007 with postgressql/postgis Database and also add PostGIS provider in FDO2FDO. Connection is OK. But after assignig source attribute with destination table attribute and providing Source class name: [SDF file name] and Destination class name: [Destination Table name] and when press Run Copy Task then it show Error:c_FDO_Api::CopyFdoClass:Unable to find Class 'mouza' in destiantion!. but mouza table is persent in destination database. Rahul anything wrong in my step ? I also transfered SHP file using OGR2OGR in Postgres but due to performance problem i want to transfer sdf or shp file directly in database table using FDo2FDO. Rahul is it posible ? if you have any idea, how to transfer all data in PostgreSQL/PostGIS database using FDO2FDO then help me. I am asking to you because you already used PostgreSQL. Thankyou in Advance.
Regards, Dhirendra Kumar Rahul-2 wrote: > > Hi, > OracleXE is free to download ,you can check on oracle > website,Regarding the slowness its nothing to do with PostGIS Database as > i already used some other webGIS solutions and no problem regarding > selection or anything ,may be something to do with OGR Provider(No Idea) > may be better clarification required from Tarain or Kenneth. > > I think you try with SDF and 20 layers are not important ,the important > thing is data size and if you follow the "Guide--implementing best > practises using the MapGuide",i think u can work with 20 layers,just try > to work through with SDF if you have no customer limitations regarding the > Database. > > Cheers > Max !! > > Dhirendra Kumar <[EMAIL PROTECTED]> wrote: > > Hi Rahul, > > Thankyou for suggestion. I want to use free database i have not idea about > OracleXE, it is free or not ? but i already test PostGIS. PostGIS is slow > in > compare of MySQL. In PostGIS when i select one polygon then polygon > higlight > after few second on my local machine. Any method to increase PostGIS > performence ? 20 layers in my project so i think SQLite will be not good > for > this project. help me. Thankyou in Advance. > > Regards, > > Dhirendrs Kumar > > Rahul-2 wrote: >> >> Hi, >> I think you can try OracleXE and use King Oracle Provider 0.7.1 >> or you can try PostGIS as both are much better Spatial Databases as >> compared to MySQL. >> >> SDF uses SQLite inbuilt database so i think for small scale not for >> enterprise solution SDF will also be an option to consider upon >> seriously. >> >> Cheers >> Max >> >> Dhirendra Kumar wrote: >> >> Hi Kenneth, >> >> Thankyou for replay and giving suggestion once again. I can't use Oracle >> as >> a FDO Database so for that resion i want use MySQL. you mentioned in 3rd >> no. >> points Use another provider, so which provider is better ? and another >> thing >> you mentioned transfer all data using sdf file. So i transfered all data >> in >> MySQL database using FDO2FDO, 1st i convert shp file to sdf and after >> that >> importing sdf file in MySQL using FDO2FDO.Kenneth, any thing wrong in my >> steps ? I am waiting for your suggestion. >> >> Regards, >> Dhirendra Kumar >> >> >> Kenneth, GEOGRAF A/S wrote: >>> >>> As someone else mentioned, the selection problem is a known bug in the >>> MySQL provider. >>> You have the following options: >>> 1. Wait until someone fixes the problem. >>> 2. Download source and fix it yourself (or perhaps pay someone to do it) >>> 3. Use another provider >>> >>> If you MUST use a "real" database, I can only suggest Oracle (you have >>> tried the others). >>> Are there any reason that you cannot use SDF files? >>> >>> Regards, Kenneth, GEOGRAF A/S >>> >>> >>> >>> Dhirendra Kumar skrev: >>>> Hi All, >>>> >>>> Sorry for repeating this qustion. I tested MS SQL server, MySQL, >>>> Postgresql/postGIS and i got result MySQL performance is better in >>>> compare >>>> of all, but problem in polygon selection. I want to know that, no way >>>> to >>>> solve this polygon selection problem ? :( >>>> PROBLEM:- When i select some polygon then near polygon get highlighted >>>> in >>>> place of current selection. >>>> If anyone have idea or suggestion then please help me. Thankyou in >>>> Advance. >>>> >>>> Regards, >>>> >>>> Dhirendra Kumar >>>> >>> _______________________________________________ >>> mapguide-users mailing list >>> mapguide-users@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11918234 >> Sent from the MapGuide Users mailing list archive at Nabble.com. >> >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> >> >> --------------------------------- >> Building a website is a piece of cake. >> Yahoo! Small Business gives you all the tools to get online. >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- > View this message in context: > http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11919719 > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > --------------------------------- > Building a website is a piece of cake. > Yahoo! Small Business gives you all the tools to get online. > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11941126 Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users